| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop a user navigating certain sheets
I have two worksheets, namely "Current Round" and "Current Round Detailed"
along with 6 others that are visible. What I would like to do is contain the user to the two sheets above until a command button has been clicked. The command button is "SaveAmendments", and becomes hidden once the attached code is run. I suppose the layman's way would be something like If Worksheets("Current Round").Buttons("SaveAmendment").Visible = True Then Disable moving to any sheet other than "Current Round" and "Current Round Detailed" (or maybe better to just hide the other sheets?) Prevent user closing application End If Your thoughts on the above are appreciated Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you stop user name from appearing in comment? | Setting up and Configuration of Excel | |||
| Macro stop if file in use by other user? | Excel Discussion (Misc queries) | |||
| Navigating in Excel sheets | Excel Discussion (Misc queries) | |||
| How to stop the user from seeing what's going on | Excel Programming | |||
| Navigating Excel Sheets with C++? | Excel Programming | |||
Threaded Mode
