Removing unused reference
Did you delete the code module(s) you inserted.
Alt F-11 to open the VBE
Right-click on your project file in the left panel, Remove
Regards,
Peter T
"Elliot" wrote in message
...
I have a similar problem. I experimented with recording a macro on an
excel
spreadsheet (Office 2003). It didn't do what I wanted and I deleted the
macro. Although there are no macros in this file anymore, everytime
someone
opens the file he gets a message,"Macros are disabled because the security
level is set very high, etc."
I've tried setting security low, setting it high, in the middle, to no
avail. The message keeps appearing. Frankly its a bit embarassing for me
that
all the users of this spreadsheet (there are scores of people who refer to
it) need to clik "OK" before they can use the spread sheet. All because of
my
failed experiment at creating a macro. Is there anyway to get rid of it?
|