|28 Feb 2011||#1|
| || |
Excel Macros Disabled Under W7
Last week, I received a new notebook with Win 7 professional as OS - New to me and I feel way behind time noting the posting dates on the forum. Then there is reference to W8
I have been developing a program in Excel since 1995, improving the macros and output worksheets as I go along.
To protect important cells from accidental changes, I have protected all the work sheets.
I have been using office 2010 on my previous XP-SP3 OS without a problem.
Running Office 2010 in Windows 7 OS, I encountered problems with macros.
Unlike Access and Word - where I could select trusting the developer - that option is NOT available in Excel. The security message suggests that the macros are encrypted and need to be unprotected. However, that did not solve the problem as the same message is repeated.
However, when I also remove protection from ALL the worksheets, there is some action.
Running the compatibility utility, I receive a message referring to XP SP2.
Anyone out there that can be of assistance?
|My System Specs|
|01 Mar 2011||#2|
| || |
Hopefully you will find your resolution here:
Add, remove, or view a trusted publisher - Excel - Microsoft Office
Add a trusted publisher via the Trust Center If you know that active content (macros, ActiveX controls, data connections, and so on) from a new publisher is reliable, you can add the publisher to the trusted publishers list in the Trust Center.
Important If you open a file from a publisher and you receive a warning message that there is no signature present, or that the signature is invalid, you should not enable the content or trust the publisher unless you are sure the code project comes from a reliable source. You can learn more about digital signatures and their certificates in How to tell if a digital signature is trustworthy.
Top of Page
View or remove a trusted publisher
|My System Specs|
|Similar help and support threads for2: Excel Macros Disabled Under W7|
|on board (realtek) sound disabled with creative card disabled||Sound & Audio|
|Excel 2010 Macros Will Not Run On A New Machine||Microsoft Office|
|Close Group remain disabled in Excel 2007||Microsoft Office|
|enabling macros in Excel||Microsoft Office|
|How do I set keyboard macros?||Customization|
|Excel 2003 Macros do not run correctly on a Windows 7 system.||Microsoft Office|
|Running old Excel macros in Windows 7||Microsoft Office|