Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
not open xls if macro protection
If macro are not allow, how can I visualize in xls the msg (alert o
simply text in cells) that ask to allow the macro code (and visualize nothing if macro are ok)? My desire is only that the users cannot open the xls if they the code doesn't allow. Thanks a lot M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
not open xls if macro protection
You don't have the ability to force the users to enable macro code. In fact,
if they have security set to high and the workbook is not certified by a trusted source, it is automatically disabled without user choice. You can put your code in an Addin, then the user can choose to load you addin. Or you can hide worksheets and so forth so that the user has little use for the workbook unless macros are enabled - however, any method that depends on code running to enforce this is not viable. another approach is to have two workbooks - one hidden. The first workbook uses code to open the second workbook and close itself. If macros are not enabled, then the second workbook is never opened. -- Regards, Tom Ogilvy "miro" wrote: If macro are not allow, how can I visualize in xls the msg (alert o simply text in cells) that ask to allow the macro code (and visualize nothing if macro are ok)? My desire is only that the users cannot open the xls if they the code doesn't allow. Thanks a lot M |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
not open xls if macro protection
this isn't supported.
-- Regards, Tom Ogilvy "miro" wrote: If macro are not allow, how can I visualize in xls the msg (alert o simply text in cells) that ask to allow the macro code (and visualize nothing if macro are ok)? My desire is only that the users cannot open the xls if they the code doesn't allow. Thanks a lot M |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
not open xls if macro protection
Thanks Tom.
Thank you very match. For your preciuos help. M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
When I open a workbook, cell protection is not fully active | Excel Worksheet Functions | |||
Workbook Protection so it won't open | Excel Discussion (Misc queries) | |||
Removing an open file password protection | Excel Worksheet Functions | |||
Protection lost on Open | Excel Programming |