Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help - save sheet then hide when....
I am using Excel 2003 and I'm a novice with VBA.
I have 2 worksheets(for now): Steps and Routes. I plan to have several command buttons on the Steps worksheet that when the user clicks on the button, it unhides a worksheet and places the cursor in a specific cell for that worksheet to allow the user to begin entering required data. The macro I created for the button works so far to select the "Routes" worksheet. When the user is finish entering data and selects the "Steps" worksheet, I want the Routes worksheet to be saved and then hidden. Can someone help me with the syntax to accomplish this event? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Create Sheet, Hide Sheet | Excel Discussion (Misc queries) | |||
Hide a Sheet | Excel Programming | |||
hide sheet | Excel Programming | |||
hide sheet? uncheck sheet tabs? or ??? | Excel Programming |