| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close Workbook If user disables macro's
Bob
Thanks very much job done, Michael "Bob Phillips" wrote: Make them very hidden, they can't unhide these from the menu option. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mmc308" wrote in message ... Bob Thanks for your idea, I am almost there, I have created a single worksheet that if the workbook is opened, the worksheets that they can enter data on are hidden unless the Marco's are enabled - they also re-hidden on closure. The only thing I need to disable is the Unhide worksheet from the Format menu? Can this be done on closure TIA Michael "Bob Phillips" wrote: As Tom says, you cannot do what you want, but you can make it obvious to the user that they shouldn't. One way to approach this is as follows. - create a worksheet with a message on explaining that for this workbook to run it needs macros enabled, maybe even a few screenshots - hide all other worksheets] - add some code in the Workbook_Open event that un hides the other sheets, but hides that sheet. What happens is that if they do not enable macros, they will only see the warning sheet, telling them how to do it. If the enable macros, it will startup as the workbook it should be. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mmc308" wrote in message ... I am currently looking for a way to close a workbook if the user has a lower security setting than meduim or the user chooses to disable macro's The reason for this I have a macro in the work book that checks for a data and lock the worksheet if the date has passed, however if they disable the macro's they can work on this worksheet Any idea would be appreciated TIA Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to run auto_open before user disables macros at startup | Excel Programming | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| Test for file path, alert user and close workbook | Excel Programming | |||
| Detect macro's parent workbook or worksheet | Excel Programming | |||
| don't let the user disable macro's in Excel | Excel Programming | |||
Threaded Mode
