Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In order to fix a problem in 117 worksheets I created a macro to
basically FORMAT, PROTECTION, check Locked, and check Hidden, then CTL-PGEDOWN to advance to the next worksheet. After formatting all the sheets, I deleted the macro, TOOLS, MACRO, MACROS and delete. Since doing this everytime I open the workbook I get the Security Warning pointing to the workbook with the message "Macros may contain viruses. It is usally safe to disable macros, but if the macros are legitimate, you may lose some functionality". The user will then have to choose "Disable Macro", "Enable Macro", or "More Info". I was able to remove the message by changing the Macro Security level from Medium to Low but would like to get the workbook back how it was before creating then deleting the macro. I'm afraid this will confuse the user when the new version of the workbook is readied. Anyone have any ideas. I using Excel 2003 with ASAPUtilites Addins. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling macros for my workbook | Excel Programming | |||
Enabling Macros | Excel Discussion (Misc queries) | |||
No Macros but Macro enabling message | Excel Programming | |||
macros not enabling | Excel Programming | |||
Enabling macros | Excel Programming |