| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook / worksheet change event
Is it possible to use the act of navigating to a different worksheet as an
event in VBA programming? For instance, if I had a workbook with multiple worksheets, and the primary sheet that is displayed when the workbook is opened is called "setup", I want to make sure that you cannot navigate to or view any other worksheets until all necessary changes are made to the setup worksheet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
workbook / worksheet change event
Use the worksheet Change event on the "setup" worksheet to set or clear a
global navagate_allowed flag. Use the worksheet Activate event on all other worksheets to check the flag and kick the user back to "setup" if the flag is False. -- Gary''s Student - gsnu200785 "Jeff" wrote: Is it possible to use the act of navigating to a different worksheet as an event in VBA programming? For instance, if I had a workbook with multiple worksheets, and the primary sheet that is displayed when the workbook is opened is called "setup", I want to make sure that you cannot navigate to or view any other worksheets until all necessary changes are made to the setup worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Event across every sheet in workbook | Excel Programming | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Change Workbook Event | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Linear Mode
