Open Worksheet

  • Thread starter Thread starter Richard
  • Start date Start date
R

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.
 
Add some BeforeClose/Save event code in Thisworkbook module to select another
sheet upon closing.


Gord Dibben MS Excel MVP
 
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.
 
Back
Top