Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Suppress Update Links Prompt | Excel Discussion (Misc queries) | |||
Update links without being prompt | Excel Discussion (Misc queries) | |||
Prompt for update | Excel Worksheet Functions | |||
Startup prompt - Update links | Excel Discussion (Misc queries) | |||
Prompt to update links | Links and Linking in Excel |