Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could either place hyperlinks on the sheet along with text explaining
what to expect when going to each sheet, and hyperlinks on each sheet taking them back to the original, or you could create some code that would "demo" the sheets of interest: newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 ' (seconds) waitTime = TimeSerial(newHour, newMinute, newSecond) Sheets(12).Range("A1").activate Application.Wait waitTime Sheets(23).Range("A1").activate Application.Wait waitTime You could include activating specific ranges on each sheet with the "wait" command set for the time you think appropriate and go from there to make the presentation as complex as you wish. -- Best wishes, Jim " wrote: I'm helping to lay out a simple webpage to allow users easy access to a few excel workbooks that contain all sorts of interesting things they might like to look at. Some of the workbooks are pretty overwhelming, so I'd like to link to the worksheets that contain the data the general public would find interesting (i.e. charts, and data summary sheets) I'd like a way to open a workbook to a worksheet specified in the command line if possible. I can write a macro that opens a designated worksheet, but I don't know how to get it to read a command line argument. Any help would be greatly appreciated. Thanks, Thomas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening a excel file to a specific worksheet. | Excel Discussion (Misc queries) | |||
opening new csv file in existing xls file's worksheet | Excel Worksheet Functions | |||
Grey screen on one worksheet when opening excel file | Excel Discussion (Misc queries) | |||
Opening Excel file on a specific worksheet | Excel Worksheet Functions | |||
Opening an excel file returns a blank worksheet | Excel Discussion (Misc queries) |