Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel Macros Disabled Under W7

28 Feb 2011   #1

Windows 7 Professional
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 W7 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 SpecsSystem Spec
01 Mar 2011   #2

Windows 7 Home Premium 64bit

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.
  1. Open the file from the new publisher.
  2. Click the File tab. The Backstage view appears.
  3. Under Help, click Options; the Options dialog box appears.
  4. Click Trust Center.
  5. Click Trust Center Settings; the Trust Center appears.
  6. Click Trusted Publishers.
  7. From the list, select the publisher's certificate, and then click OK.
The following image is an example of the Trusted Publishers area of 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

  1. Open a file created by a publisher
  2. Click the File tab. The Backstage view appears.
  3. Under Help, click Options; the Options dialog appears.
  4. Click Trust Center.
  5. Click Trust Center Settings; the Trust Center appears.
  6. Click Trusted Publishers.
  7. In the Trusted Publishers list, select the publisher to remove. Click Remove.
  8. Click OK.
My System SpecsSystem Spec

 Excel Macros Disabled Under W7

Thread Tools

Similar help and support threads
Thread Forum
Excel Warnings - Macros
I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message: C:\Users\AccountName\Documents\Spreadsheet.xls contains macros. Macros may contain viruses. It is always safe to disable macros, but if the macros are...
Microsoft Office
Forum for question on Macros in Excel ?
Hello, I am having problems creating a macro in Excel. The keystrokes are not recorded as I expect. Can you advise on the correct section or forum where I should submit my question? Many thanks, Ken
Microsoft Office
Excel 2010 Macros Will Not Run On A New Machine
Am running Win7 and Office 2010. Several years ago I wrote four macros to perform operations in Excel 2010. Thet we to be placed in Personal.XLS so they would be available on all worksheets. I put links to them in the Quick Access bar. Twice I have tried to use those macros on different...
Microsoft Office
enabling macros in Excel
to enable macros in Excel I have to go to Developer then enable macro. Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet. However, now...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:33.
Twitter Facebook