| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command line to open a specific worksheet
Is there a way to open a specific worksheet from the command line?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Command line to open a specific worksheet
Not really. You can use a macro called Auto_Open that would select the
sheet, Sub Auto_Open() Worksheets("Sheet3").Select End Sub But that means that Sheet3 will always be the active sheet when the file is opened. You can't supply a value from the command line. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "vIQleS" wrote in message ... Is there a way to open a specific worksheet from the command line? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Command line to open a specific worksheet
Ok - thanks
"Chip Pearson" wrote: Not really. You can use a macro called Auto_Open that would select the sheet, Sub Auto_Open() Worksheets("Sheet3").Select End Sub But that means that Sheet3 will always be the active sheet when the file is opened. You can't supply a value from the command line. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "vIQleS" wrote in message ... Is there a way to open a specific worksheet from the command line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I open a an existing excel worksheet, it duplicates itself a. | Excel Discussion (Misc queries) | |||
| Calling a specific worksheet from a hyperlink in a seperate file. | Excel Worksheet Functions | |||
| Always open a worksheet at A1 | Excel Discussion (Misc queries) | |||
| Hyperlink to specific worksheet in Excel | Links and Linking in Excel | |||
| How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Linear Mode
