Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

weird problem all of a sudden. for excel addin excel 2003

excel 2003 vba..

.xls file

I have an add-in that all of a sudden i cant see the mcros listed: by using

Tools-Macro-Macros..

nothing shows up.

??


Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
1 Solution
 
g000seCommented:
Hi, have you tried to reinstall Excel 2003?  Also, try temporarily disabling your add-in.
0
 
FordraidersAuthor Commented:
no, cant re-install. tried temp disableing  add-in also.,
0
 
tdlewisCommented:
Does this happen for every spreadsheet with macros or just this one? If it's just the one spreadsheet, can you post it?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
FordraidersAuthor Commented:
all the macros. in any .xla..
0
 
tdlewisCommented:
Have your Trust Center settings changed to disable all macros without notification?

http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx
0
 
tdlewisCommented:
I should have looked a little closer at the article I posted. It's for Excel 2007. I think the equivalent setting in Excel 2003 is "Very High".
0
 
tdlewisCommented:
...and after trying various combinations in Google, I finally found this article that might address your situation:
http://answers.microsoft.com/en-us/office/forum/office_2003-excel/need-to-know-how-to-re-activate-macros-in-the/8f3c2c94-3667-4aa0-8677-c6d47793f5e4?tab=MoreHelp
0
 
FordraidersAuthor Commented:
settings =  Low
0
 
tdlewisCommented:
OK... and what do you see in the macro editor?
0
 
FordraidersAuthor Commented:
i'm able to see macros in my workbook...but no macros for the Add-in ?
0
 
tdlewisCommented:
When you open Tools->Macro->Macros, does the add-in appear in the "Macros in" drop down?

If you open the Add Ins dialog, does the add in appear there? If so, what is it's state (enabled or disabled)?
0
 
FordraidersAuthor Commented:
When you open Tools->Macro->Macros, does the add-in appear in the "Macros in" drop down?

no

If you open the Add Ins dialog, does the add in appear there? If so, what is it's state (enabled or disabled)?

when i'm in the vbe i can see the macros...
enabled
0
 
FordraidersAuthor Commented:
here is the add-in
Karnuth-Audit.zip
0
 
tdlewisCommented:
Unfortunately, I cannot run macros directly from an XLA file in Excel 2007. However, when I copied your macros into a macro-enabled file in my XLSTART directory they showed up in my macros list.

Perhaps your XLA file is corrupted. Try copying the macros into a fresh file and saving it. If that doesn't work, I'm out of ideas.
0
 
Rory ArchibaldCommented:
Add-in macros should never appear in the macros dialog. That is normal behaviour.
0
 
FordraidersAuthor Commented:
Thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now