Open Worksheet

[Richard]

I have a workbook with several worksheets. On one of my worksheets I
have a userform that opens up when that worksheet is selected
(Activated). But when the user saves then closes the workbook and the
next time the workbook is opened, it opens to that worksheet so the
userform does not open. How can I say Activate only if that sheet is
active.

 

[Gord Dibben]

Add some BeforeClose/Save event code in Thisworkbook module to select another
sheet upon closing.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Or use the Auto_Open/workbook_open procedures to check to see what the
activesheet is. Then run the procedure to show the form if that sheet is active.