Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
I have declared a subroutine:
Private Sub Worksheet_Activate() with the belief that this is executed when the sheet or workbook opens However, when I have closed the workbook and re-opened, the code ha not been executed. I have put Debug.Print statements at the beginnin and end but Excel doesn't even enter this code. Are there an circumstances under which this might happen -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
Did you do this in the sheet code module or a general module?
It must be in the sheet's module. Pozzo < wrote: I have declared a subroutine: Private Sub Worksheet_Activate() with the belief that this is executed when the sheet or workbook opens. However, when I have closed the workbook and re-opened, the code has not been executed. I have put Debug.Print statements at the beginning and end but Excel doesn't even enter this code. Are there any circumstances under which this might happen? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
I need to have this code run specifically for this sheet, though, so
can't attach it to a workbook event. I've just found out that the code executes when a move away to anothe sheet and then come back, just not when the workbook opens with thi sheet as the active sheet. Is this how it is supposed to work -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
The ThisWorkbook event only activates a macro it doesn't restrict the scope of the macro (i.e. you can use it to activate a macro to run formulas on sheet1)
Yes it will activate if you unselect the sheet and re-select it. That's how it is supposed to work. If you need to run when open the workbook you need the "ThisWorkbook_Open()" event. You could go to another sheet and save it. When you open the workbook again you would be forced to select that sheet again, hence, activate the event (I don't recommend that) ----- Pozzo wrote: ---- I need to have this code run specifically for this sheet, though, so can't attach it to a workbook event I've just found out that the code executes when a move away to anothe sheet and then come back, just not when the workbook opens with thi sheet as the active sheet. Is this how it is supposed to work -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Activate not working for multiple cells | Excel Discussion (Misc queries) | |||
Worksheet_Activate | Excel Programming | |||
Why wouldn't calling the Activate sub for a sheet automatically call that sheet's Worksheet_Activate() sub? | Excel Programming | |||
Automation Procedure with Worksheet_Activate | Excel Programming |