did you try the code on the thisworkbook code page
Private Sub Workbook_Open()
--


Gary


"mikeburg" wrote in
message ...

I have sheet activate code for every worksheet in a workbook.

I have auto_open code that selects the sheet named data.

The proplem is if the sheet named data was active when I exited the
workbook, the sheet active code for data will not execute when opening
the workbook. I have click another sheet then click back into the sheet
named data to get the code to execute.

Any ideas would be greatly appreciated. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=490371