workbook / worksheet change event

J

Jeff

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.
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect each worksheet individually 4
Combine multiple worksheets in one Workbook into one big worksheet 6
How to get worksheet_activate code to run when a workbook is opened 1
VBA Error Handling 4
Copying Data from a workbook to another workbook 1
Handling a worksheet calculate event in XLA code 4
Worksheet CodeName property 1
Excel crashes and restarts when accessing newly created worksheet 2

Top