| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open 'n' Hide
Hi all, I'm trying to run a piece of VB that, on opening the spreadsheet, hide a number of worksheets and also takes the user to a predefined sheet Here's what I tried: Private Sub Workbook_Open() Sheets("User Select").Activate Sheets("Programme(High Level)").Visible = xlVeryHidden Sheets("Programme (2 Week)").Visible = xlVeryHidden Sheets("Programme (Components").Visible = xlVeryHidden Sheets("Capacity").Visible = xlVeryHidden Sheets("Extra Fees Calculator").Visible = xlVeryHidden Sheets("Control").Visible = xlVeryHidden End Sub Something wrong here though...any suggestions what I can do to rectif this? TIA, Samuel -- Samuel ----------------------------------------------------------------------- SamuelT's Profile: http://www.excelforum.com/member.php...fo&userid=2750 View this thread: http://www.excelforum.com/showthread.php?threadid=55259 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide sheet on file open | Excel Discussion (Misc queries) | |||
| Open and Hide a workbook | Excel Discussion (Misc queries) | |||
| how do i hide columns in excel so no one can open them. | Excel Discussion (Misc queries) | |||
| open and hide | Excel Programming | |||
| Open with VBA - hide passwords in code? | Excel Programming | |||
![SamuelT[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
