Showing related tags and posts accross the entire site.
-
I would like to receive an email notification with a hyperlink to an excel workbook whenever someone completes said workbook (actually a customized template we use for each of our individual projects). After a little digging, one approach seems to be to create a beforeclose event with a customized dialog...
-
Hello. Here is my goal in its simplest form. I have a list of data in column A (for example, A5:A10). I have a row of boxes (merged cells) in row 2. I would like to write VBA code that would allow me to click on a piece of data from column A, "drag" it to one of the boxes (merged cells), and...
-
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...