LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default Enabling Macros message when NO macros in workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enabling macros for my workbook Maddoktor Excel Programming 1 February 25th 06 02:42 PM
Enabling Macros Old Music Lover Excel Discussion (Misc queries) 2 July 23rd 05 02:07 AM
No Macros but Macro enabling message Hari Prasadh[_2_] Excel Programming 9 July 5th 05 09:26 AM
macros not enabling James[_10_] Excel Programming 2 September 4th 03 03:04 PM
Enabling macros Tom Ogilvy Excel Programming 0 August 18th 03 03:48 PM


All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"