Getting rid of Macro and Update Prompt

  • Thread starter Thread starter Kat
  • Start date Start date
K

Kat

I received an excel file that has macros. This sheet has 4 tabs, on one tab
I enter in multipliers and it propagates pricing for customers. Not each
customer gets the same multipliers so I change it and save the file again
under the customers name. I have about 35 files now that I will be emailing
out to different customers. Before I do so, I remove the tab that contains
the muliplier on it.

When I save the file, close it and then reopen it asks the "enable/disable
macros" which I do not need now, I'd like to get rid of that prompt if
possible (for good so customers don't have to deal with it).
After that is cancelled then it asks to update the file from the tab thats
been deleted and there is nothing to update, the numbers stay the same. I'd
like to get rid of that for good as well, so customers don't have to deal
with that either.

I would just like them to see the clean price sheet, that's it.

Does anyone know of a way I can:
1. Delete the macro prompt, I go to Macro and delete but there is no macro
listed.
2. Delete the prompt for updating as no updates are needed

I'm using Excel 2000 on Win XP, Pro.

If anyone has suggestions, please let me know. Thanks

Kat
 
To remove the macro prompt, you need to remove the module the macro was
stores in. Open the VBE (Alt+F11), and in the Project Explorer window
(usually top-left) remove the modules. This should clear out the remaining
traces of the macros.

For the formula updating, back in XL, under Edit-Links, you can choose to
break the links, thus converting all linked values to static values.
 
Back
Top