Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Worksheet_Activate()
Please help
I wrote a code which should automaticly run but it does not work The strange thing is that it works on some of the PCs in the office. I use office 2003. I have previous experiance with VBA and event handel procedures. May be it is some options or propperies ...i dont know The code is Private Sub Worksheet_Activate() msgbox("test") End Sub Regards Teodor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Worksheet_Activate()
Obvious question - have you put it in the worksheet module?
-- HTH RP "Teodor Bobochikov" <Teodor wrote in message ... Please help I wrote a code which should automaticly run but it does not work The strange thing is that it works on some of the PCs in the office. I use office 2003. I have previous experiance with VBA and event handel procedures. May be it is some options or propperies ...i dont know The code is Private Sub Worksheet_Activate() msgbox("test") End Sub Regards Teodor |
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 | |||
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 |