| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable workbook
I would like to not allow a user to open a workbook if she/he does not enable
macros when prompted. Is there a cool way to do this? I have some code in the Workbook_Open that must run when the workbook is open. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable workbook
If macros are not enabled, no code runs.
"Roxy" wrote: I would like to not allow a user to open a workbook if she/he does not enable macros when prompted. Is there a cool way to do this? I have some code in the Workbook_Open that must run when the workbook is open. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable workbook
the common way most deal with this problem is to hide all but one sheet when
saving & closing your workbook. This sheet would be displayed when macro's are not enabled next time workbook is opened, showing a message informing user that macro's must be enabled. If however, macros are enabled then other worksheets are unhidden & message sheet hidden. Sounds tad complicated but can be made to work for most uses. Have a look at this site for some idea how to approach the problem. You can google other sites for further samples http://www.dotxls.com/excel-security...e-excel-macros Hope helpful -- jb "Roxy" wrote: I would like to not allow a user to open a workbook if she/he does not enable macros when prompted. Is there a cool way to do this? I have some code in the Workbook_Open that must run when the workbook is open. Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable workbook
Nice answer John! Thinking 'out of the box'.
-- Alan Moseley IT Consultancy http://www.amitc.co.uk "john" wrote: the common way most deal with this problem is to hide all but one sheet when saving & closing your workbook. This sheet would be displayed when macro's are not enabled next time workbook is opened, showing a message informing user that macro's must be enabled. If however, macros are enabled then other worksheets are unhidden & message sheet hidden. Sounds tad complicated but can be made to work for most uses. Have a look at this site for some idea how to approach the problem. You can google other sites for further samples http://www.dotxls.com/excel-security...e-excel-macros Hope helpful -- jb "Roxy" wrote: I would like to not allow a user to open a workbook if she/he does not enable macros when prompted. Is there a cool way to do this? I have some code in the Workbook_Open that must run when the workbook is open. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Pasting into a Workbook | Excel Worksheet Functions | |||
| Disable commands for one workbook | Excel Programming | |||
| Disable cut paste in a workbook | Excel Programming | |||
| Disable the opening of another workbook | Excel Programming | |||
| Disable a command from with in a workbook | Excel Programming | |||
Hybrid Mode
