| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a value from Sheet1-A1:A10 in Sheet2-B1 | Excel Worksheet Functions | |||
| Click one cell sheet1, display all related recs on sheet2 | Excel Worksheet Functions | |||
| If Sheet1 column is marked complete, display entire row on Sheet2? | Excel Worksheet Functions | |||
| Display Rows From Sheet1 In Sheet2 (Import) | Excel Worksheet Functions | |||
| Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 | Excel Worksheet Functions | |||
![lothario[_26_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
