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