problems with macros in exel 2003

G

Guest

when opening some excel files, i get a macro security warning. I go to the
tools, macro section, but there are no macros there. Why do i get the error
on some files and not others?
 
G

Guest

If there used to be a macro in a modulr, and the macro was deleted, you may
still get a warning if the module exists (even if it is now empty).

Delete the module as well.
 
G

Guest

Thanks for the input. How do I delete the module? (What is a module? And
how did it get there?) I don't know too much about excel, just the very
basics.
 
G

Guest

In Excel touch ALT-F11 This will bring up the VBE. If there is no expolorer
pane on the left-hand side touch CNTRL-R. If you see modules on the
left-hand side, then right-click them and specify remove.
 
G

Guest

Thanks. Solved the problem. It looked like something was recorded, but it was
over 2 years ago. I just upgraded to 2003, and never had the problem before
this.
 

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

Top