 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008workbook / 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. 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.  SignatureGary''s Student - gsnu200785 > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.