Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro and sub rountines | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro for multiple charts | Excel Worksheet Functions |