How to open specific sheet at book open?
Posted by Russ Posey on September 27, 2000 6:21 AM
My client has a workbook with several sheets. Upon opening the XLS file, they would like the book to open to a certain sheet. The sheet they want is variable: it could change by day, who clicked this shared XLS, etc. Is this possible (perhaps in a stattrtup macro)?
My initial thought (I have a VB background) would be to include a command line parameter in the shortcut to the file, read it and go to that sheet upon opening the workbook. Is this possible?