Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2014, 02:50 PM
PeteNC PeteNC is offline Excel 97 macros no longer run Windows 7 64bit Excel 97 macros no longer run Office 2007
Novice
Excel 97 macros no longer run
 
Join Date: Dec 2014
Posts: 4
PeteNC is on a distinguished road
Default Excel 97 macros no longer run

I'm using an older version of Excel (2007) on a Windows 7 desktop. For years the macros I've written have worked fine. Today I get this message when I try and run a macro "The macro may not be available in this workbook or all macros may be disabled." I've looked into the Trust Center Settings and they are set to Enable All Macros.
Do any of you know why this happened all of a sudden and how I might be able to have them function again?
Thanks for considering this.
Pete
Reply With Quote
  #2  
Old 12-07-2014, 05:24 PM
whatsup whatsup is offline Excel 97 macros no longer run Windows 7 64bit Excel 97 macros no longer run Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi Pete

Honestly, the whole Trust Center is a chapter of its own, I'm as well still battling with its settings and notifications.
But what we will need is more information on the issue:
- Do you get any notification regarding the macros when opening the file? (Sometimes it's only a line of notification which apears on top of the columnheaders)
- Did you use the files before on this computer with Win7 and Office 2007 or are you using them now the first time?
- Have you assigned any Trust-Certificates to the files?

Cheers
Reply With Quote
  #3  
Old 12-07-2014, 05:34 PM
PeteNC PeteNC is offline Excel 97 macros no longer run Windows 7 64bit Excel 97 macros no longer run Office 2007
Novice
Excel 97 macros no longer run
 
Join Date: Dec 2014
Posts: 4
PeteNC is on a distinguished road
Default

Thanks for the reply. There is no indication when opening the files that there is any problem at all. I've been using these macros in several spreadsheets for over two years. Until this morning, they worked like a charm.
I'm not familiar with assigning Trust-Certificates. I'll look into that tonight. Thanks very much.
Pete
Reply With Quote
  #4  
Old 12-07-2014, 06:22 PM
PeteNC PeteNC is offline Excel 97 macros no longer run Windows 7 64bit Excel 97 macros no longer run Office 2007
Novice
Excel 97 macros no longer run
 
Join Date: Dec 2014
Posts: 4
PeteNC is on a distinguished road
Default

I added the folders to the trusted locations and that did the trick. Thanks for pointing me in the right direction.
Pete
Reply With Quote
Reply

Tags
macro not be available



Similar Threads
Thread Thread Starter Forum Replies Last Post
I can no longer open Excel in Multiple Windows stevetag Excel 2 01-24-2014 03:05 PM
Excel 97 macros no longer run Run macros between excel and access Jhouk5244 Office 1 08-18-2011 11:06 AM
macros to excel evh Excel Programming 0 07-20-2011 10:12 PM
Oulook Deletes Emails Attached with Excel Files That Have Macros Slacker Outlook 4 01-24-2011 03:17 PM
Excel 2003 SP3 bug when running Macros EnricoVenturi Excel 0 09-06-2009 08:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft