View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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?