Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Excel 2007: Macros disabled when workbook is protected (why?)

MS has provided this information:

http://support.microsoft.com/kb/927150/en-us

--
Jim
"Felipe" wrote in message
...
| Hi,
| I'm running into the following situation wich seems to present a different
| behaviour in Excel 2007 than in 2003 and one that I can't understand. I
will
| appreciate any help or comments.
|
| Macro Security = "Disable all macros with notification".
|
| When opening a workbook (.xlsm) with a macro included on it, the message
| bar correctly shows me the "Security Warning: Macros have been disabled"
| message, and offers me the option to "Enable this Content" when clicking
on
| the Options... button.
|
| After protecting the same workbook with the Protect Workbook feature and
| opening the file again, the same message is shown in the message bar but
the
| "Enable this Content" option is not available in the dialog opened with
the
| Options... button and the following message is shown on the same dialog:
|
| "This file contains encrypted macros that have been disabled because there
| is no antivirus software installed that can scan them. To run these
macros,
| remove the encryption or permission restrictions on the file."
|
| Any comments on why the Protect Worksheet is interfering with the macro
| security? I haven't found a way to enable the macros without unprotecting
the
| workbook. I've test this with a very simple sample workbook.
|
| Thanks,
| Felipe


Reply
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
unprotect (in Excel 2007) workbook created and protected in Excel DonJ_Austin New Users to Excel 7 October 2nd 08 03:49 PM
Excel 2007 - Encrypted and password protected Workbook Ron New Users to Excel 0 August 7th 08 08:21 PM
When workbook is reopened, macros are disabled Marjie Excel Programming 3 January 26th 05 04:16 PM
Workbook opened with macros disabled Alan.Hutchins Excel Programming 1 July 28th 04 09:44 AM
Excel crashes when attempting to open workbook...even with macros disabled llowwelll[_10_] Excel Programming 1 May 24th 04 09:38 PM


All times are GMT +1. The time now is 10:06 AM.

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

About Us

"It's about Microsoft Excel"