ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Private Sub Worksheet_Activate() (https://www.excelbanter.com/excel-programming/311673-private-sub-worksheet_activate.html)

Teodor Bobochikov

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

Bob Phillips[_6_]

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





All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com