![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Feb 2002
Posts: 10
|
I have a workbook with a variety of macros. I would like to atuomatically "enable macros" on opening of the workbook from any one of the users (potentially 30 or more users so I don't want them to "disable" the macros). Is there a way that I can remove the pop-up box that comes up to "enable macros" or "disable macros" on opening the workbook?
Thank you! Anita |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
In one word, No.
One option would be to get a Digital Signature and sign your project with it, that way, even if the user has macro security set to High, your project will load. If they have it set to Medium, they'll have the option to enable/disable macros. |
|
|
|
|
|
#3 |
|
Guest
Posts: n/a
|
Juan,
Thank you for your answer. I didn't think there would be an easy way to handle it. Anita |
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|