Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting default "open" worksheet in a workbook
I have an Excel workbook with multiple worksheets included. I want to
set a specific worksheet as the default when opened. Is this possible and if so how do I do it? If it is a macro could you give me the code? Thanks Much! ;) --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting default "open" worksheet in a workbook
Hi
put the following code in your workbook module Private Sub Workbook_Open() Worksheets("your sheet name").activate End Sub -- Regards Frank Kabel Frankfurt, Germany I have an Excel workbook with multiple worksheets included. I want to set a specific worksheet as the default when opened. Is this possible and if so how do I do it? If it is a macro could you give me the code? Thanks Much! ;) --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get Excel 2007 to its default "factory setting" | Excel Discussion (Misc queries) | |||
How can I get Excel 2007 to its default "factory setting" | Excel Discussion (Misc queries) | |||
Excel ignores "Sheets in new workbook" setting | Excel Discussion (Misc queries) | |||
change the file open default permanently to "All files" | Excel Discussion (Misc queries) | |||
How do I set the default to "Open" or "New" for a template | Excel Discussion (Misc queries) |