Parameters to open a specifice worksheet within a workbook from a command line.
Posted by Wayne Sharp on January 25, 2002 9:13 AM
This has got to be simple as dirt but I haven't found anyone that can give me the command line parameters to open a specific worksheet within a workbook.
Example: Workbook One has sheets one, two, three, four. I want a link on my desktop to go directly to sheet three within workbook one. Also a link to go to sheet four, etc.
I tried to create a command line parameter to open a workbook then run a macro that went to a specific sheet but didn't do something right. As far I know only one auto open macro is allowed, so that won't work to open different worksheets.
Thank you for any help given.