What macros?

  • Thread starter Thread starter Roy Rutherford
  • Start date Start date
R

Roy Rutherford

Everytime I open my Excel spreadsheet ( a fairly large one I use every day),
on a differant computer I get a warning offering to disable Macros in the
worksheets. I am not aware of any macros in my worksheets. When I access
the Tools: Macros; menus I find no macros listed. Are there invisable
macros? I don't need any macros and would just as soon strip any hidden
macros. I set this spreadsheet up and it does what I need, I don't se
macros, cuz I have not figured out what they do or where they live..

Anyone have any insight or ideas?
 
Roy, yes there are "invisable" macros, ones you can't see from tools macros,
have a look here on where to look for them

http://www.contextures.com/xlfaqMac.html#NoMacros
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Also, it's possible there were macros that were deleted leaving an empty
module which should be removed.
 
Thanks for the time and the help. That cleaned it up quite nicely. I had 6
empty modules.

Thanks again,
Roy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Not Changing Date Values 7
Excel Macro for deleting Rows containing dates greater than "today" 0
Still getting Macro Security Warning Message after removing Macro 3
Create macro to reformat spreadsheet 1
How to see list or names of the macros in a spreadsheet 1
Copy Columns based on Header name 1
Remove macro warning 1
Macro to find spaces? 6

Back
Top