Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing Macros to Run (Else Deny Access to Workbook)
Hi All,
I seem to recall occasionally opening a workbook that has macros in it and, upon asking Excel to 'disable macros', being informed that the workbook contained macros written in Excel 4 which cannot be disabled. In that situation, if I recall correctly, I was given two choices: 1) Open the workbook with the macros enabled; or 2) Don't open it at all. At the time I was quite annoyed, but now it seems to me to be a good way to avoid staff from disabling the macros within a shared workbook where I really need for them to be active. Is there still a way, using Excel 2000 (or Excel 97), to create an Excel 4 macro that will ensure users have to enable macros? The macro does not need to do anything in particular I guess, just being there should be enough? Thanks in advance, Alan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing a workbook to open on a certain page | Excel Discussion (Misc queries) | |||
Deny/Allow for certain range. | Excel Discussion (Misc queries) | |||
deny printing for certain blank cells | Excel Worksheet Functions | |||
How do I deny opening and viewing any file to any user and lock i. | Excel Discussion (Misc queries) | |||
Deny file access if user declines macros? | Excel Discussion (Misc queries) |