Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks and opening any sheet a workbook
Is there any way to open a sheet in a workbook through a hyperlink. Eg. if
there are 3 sheet in a workbook and it was saved with the first sheet displayed can you use a hyperlink to open sheet 2. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks and opening any sheet a workbook
no
You could use VBA in the workbook's Open event so that it checks something and switches to the relevent sheet...but that depends on the condition eg save a text file in the same folder & give it th esheet name. the event handler could read the filename & slect the sheet. or inside the textfile write the sheet name etc etc "Angelo Battistoni" wrote: Is there any way to open a sheet in a workbook through a hyperlink. Eg. if there are 3 sheet in a workbook and it was saved with the first sheet displayed can you use a hyperlink to open sheet 2. Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks and opening any sheet a workbook
If you want Sheet2 to be the activesheet when the workbook is opened, you
can put code to do this in the Workbook_Open event. Private Sub Workbook_Open() thisworkbook.Worksheets("sheet2").Activate End sub This must be placed in the ThisWorkbook module of the project if the user doesn't disable macros on opening or if macros are not disabled by security settings, then this will activate sheet2 on opening. See Chip Pearson's page for general information on using events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Angelo Battistoni" wrote in message ... Is there any way to open a sheet in a workbook through a hyperlink. Eg. if there are 3 sheet in a workbook and it was saved with the first sheet displayed can you use a hyperlink to open sheet 2. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
only the last sheet tab appears when opening workbook | Excel Discussion (Misc queries) | |||
Opening workbook at sheet required. | New Users to Excel | |||
Opening a workbook to a chosen sheet? | Excel Discussion (Misc queries) | |||
Opening a workbook at a specific sheet | Excel Programming | |||
autorun code when opening sheet (not workbook) | Excel Programming |