How? Force Sheet1 to display each time the workbook is opened.
 

Hi,

This workbook has 20 sheets.

How can I ensure that whenever this workbook is opened:
a. Sheet1 is the active.
b. Even if the last "Save" was done when the user was in some oher
sheet.

I just need the user to view Sheet1 before he moves on to any other
sheets.

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How? Force Sheet1 to display each time the workbook is opened.
 

Add to your Workbook_Open event:
Sheet1.Activate

"lothario" wrote in message
...
Hi,

This workbook has 20 sheets.

How can I ensure that whenever this workbook is opened:
a. Sheet1 is the active.
b. Even if the last "Save" was done when the user was in some oher
sheet.

I just need the user to view Sheet1 before he moves on to any other
sheets.

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How? Force Sheet1 to display each time the workbook is opened.
 

Thank you Cliff.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/