Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel Error Message Help


(!)

ariffinaldo's Avatar
ariffinaldo ariffinaldo is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
07-Aug-2012, 10:05 PM #1
Question Excel Error Message Help
Hi all, I am Ariffin and i am from Singapore. I have a problem with Excel 2007 and i found your this forum to be very helpful. I hope i can get some help in here. :-)

I have an excel workbook that is used in my company and it has many macros ( buttons, etc..). It worked fine till i had to re format my PC.

Now when i open the same file i get this error " Cannot run the macro "filename.xls". The macro may not be available in this workbook or all macros may be disabled."

I have enabled all macros in the developer tab but i am still getting this error. Microsoft help file is not really helpful. What steps am i missing here.

Further information, this file is on a network shared folder and all other PCs is able to open it without any problem except for mine.

Last edited by ariffinaldo; 07-Aug-2012 at 10:15 PM..
pip22's Avatar
Member with 2,536 posts.
 
Join Date: Nov 2004
Location: England, UK
Experience: Intermediate
08-Aug-2012, 01:20 PM #2
It seems you are not enabling macros in the right place. The instructions given in the link below make no mention of the Developer tab, so presumably that's only for when you are creating macros. Follow instructions here to enable existing macros: http://www.mdmproofing.com/iym/macro...html#excel2007
ariffinaldo's Avatar
ariffinaldo ariffinaldo is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 04:52 PM #3
Thank you pip22.. Gonna try that in office later.. Will update soon..
ariffinaldo's Avatar
ariffinaldo ariffinaldo is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
13-Aug-2012, 02:52 AM #4
Hi there, I am using Microsoft SP3 actually and i am still facing the problem. I have tried the registry workaround method recommended by Microsoft even though i was warned that it should not be done for SP 2 and above. I am at a total loss. Is there anything else that i can do. Any help will be appreciated.
Garf13LD's Avatar
Garf13LD Garf13LD is offline
Member with 455 posts.
 
Join Date: Apr 2012
Experience: Intermediate
13-Aug-2012, 09:20 PM #5
Go to trusted location and add network files to your trusted location.
http://office.microsoft.com/en-us/ex...in=HP010096919
  1. If you want to create a trusted location that is not local to your computer, select the Allow trusted locations on my network (not recommended) check box.
ariffinaldo's Avatar
ariffinaldo ariffinaldo is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
13-Aug-2012, 09:38 PM #6
Quote:
Originally Posted by Garf13LD View Post
Go to trusted location and add network files to your trusted location.
http://office.microsoft.com/en-us/ex...in=HP010096919
  1. If you want to create a trusted location that is not local to your computer, select the Allow trusted locations on my network (not recommended) check box.
I have already done that part actually previously. Nonetheless i tried one more time to the specific folder, but the macro still fails to open and i am still recieving the same error message. The same file can be opened from another colleague's PC. So there is no actual problem with the excel. Just in my PC. I am running Norton 360 if that helps. I have also tried disabling all AV but to no avail.
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
13-Aug-2012, 11:46 PM #7
Hi there, welcome to the board!

What workbook does it say the workbooks are in? Sounds like you're clicking buttons that have code linked to another workbook. If it was in, say, a Personal.xls workbook, and if you also didn't save the workbook, chances are pretty good the workbook, and the code along with it, are gone. If it works on others machines, maybe you could see what workbooks the code is referring to. Or you could tell us what the error message says exactly.

As a side note, if using code in other "home cooked" projects you should enable access to the VBAProject object model. If you look in the link pip22 posted and look at step 4, you will see the checkbox at the bottom of that picture. You should check that box as well.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑