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

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/

Yes, it is in the module for that sheet.


---
Message posted from http://www.ExcelForum.com/