Macro that wont go away - Help
 

Hello,

I created a simple print macro in a worksheet. When another user opened the
workbook there was a message something to the effect that the macro or link
was not connected and they could not make any changes or do anything in the
workbook it was locked. I went back to my desk brought up the worksheet and
deleted the macro. I probably selected something other than this workbook
when creating it.

Anway I deleted the macro however the other users now get a message to
enable or disable the macro. I deleted the macro. Where else can it be? How
can I get this to stop. I had the other users change their security to low
in order to be able to get into it.

Help would be greatly appreciated.
Thanks

I would probably check the existence of VB Code using ALT+F11.

"taxmom" wrote:

Hello,

I created a simple print macro in a worksheet. When another user opened the
workbook there was a message something to the effect that the macro or link
was not connected and they could not make any changes or do anything in the
workbook it was locked. I went back to my desk brought up the worksheet and
deleted the macro. I probably selected something other than this workbook
when creating it.

Anway I deleted the macro however the other users now get a message to
enable or disable the macro. I deleted the macro. Where else can it be? How
can I get this to stop. I had the other users change their security to low
in order to be able to get into it.

Help would be greatly appreciated.
Thanks

taxmom,
You also have to remove the modules on which the macros were stored have a
look here for details 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


"taxmom" wrote in message
...
Hello,

I created a simple print macro in a worksheet. When another user opened
the
workbook there was a message something to the effect that the macro or
link
was not connected and they could not make any changes or do anything in
the
workbook it was locked. I went back to my desk brought up the worksheet
and
deleted the macro. I probably selected something other than this workbook
when creating it.

Anway I deleted the macro however the other users now get a message to
enable or disable the macro. I deleted the macro. Where else can it be?
How
can I get this to stop. I had the other users change their security to
low
in order to be able to get into it.

Help would be greatly appreciated.
Thanks

Thank you. The data in the link was very helpful. I had to remove the
module1. It seems to be gone.

thanks so much!



"Paul B" wrote:

taxmom,
You also have to remove the modules on which the macros were stored have a
look here for details 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


"taxmom" wrote in message
...
Hello,

I created a simple print macro in a worksheet. When another user opened
the
workbook there was a message something to the effect that the macro or
link
was not connected and they could not make any changes or do anything in
the
workbook it was locked. I went back to my desk brought up the worksheet
and
deleted the macro. I probably selected something other than this workbook
when creating it.

Anway I deleted the macro however the other users now get a message to
enable or disable the macro. I deleted the macro. Where else can it be?
How
can I get this to stop. I had the other users change their security to
low
in order to be able to get into it.

Help would be greatly appreciated.
Thanks