Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enable Macros
I have macros in a worksheet that others use. Can i have the macros enabled
without it prompting the user when they open the worksheet? Thanks :) |
#2
|
|||
|
|||
Only if the other users set their macro security level to 'Low' which is a
potentially dangerous thing to do. Malicious code, viruses, can easily be included in Excel macros, hence the warning on opening,. If the warning could be disabled by the writer of the code, the virus writers would have a field day, Regards, Alan. "excelnewbie" wrote in message ... I have macros in a worksheet that others use. Can i have the macros enabled without it prompting the user when they open the worksheet? Thanks :) |
#3
|
|||
|
|||
You can use the 'selfcert.exe' program that's part of MS Office to create a
digital signature. Then you sign your macros (tools / macros / visual basic editor, then from within the VB editor, tools / digital signature and select your new signature). Have your users set their security to medium (they'll have to exit and restart Excel for the change to take effect). Then when they open your macro file the first time, they should be prompted. Have them indicate that you are a trusted author. Next time, the macro should be available without the warning. "excelnewbie" wrote: I have macros in a worksheet that others use. Can i have the macros enabled without it prompting the user when they open the worksheet? Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can not enable macros | Excel Worksheet Functions | |||
Enable macros automatically for a workbook | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
macros enable | New Users to Excel | |||
How do I stop Excel from prompting to enable or disable macros? | Excel Discussion (Misc queries) |