• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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