ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protection Question - Help Please (https://www.excelbanter.com/excel-discussion-misc-queries/182759-protection-question-help-please.html)

Baz

Protection Question - Help Please
 
I have created a workbook with several sheets. I have timed the sheets to
stay open for a specific period of time and them move to the next. On the
final sheet I have at this point allowed it to stay active until the file is
closed by the user.

Questions:

1. How do I prevent someone from going into VB Editor and seeing my code?
2. If someone is on any page before the last one they can hit escape and go
directly to the final page. How do I prevent this from happening?
3. On the final page I would like to create a "close\end" button rather than
letting the user close it. with a normal "exit." I do have some graphs on
this final page driven by some macros so I also want the user to be able to
play with thise macro buttons and have the graphs change. Is this doable?

Thanks in advance for any solutions\comments.

baz


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com