Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maccro Enabled message
We set up a spreadsheet that had macros in it. I deleted the macros, but our
users are still getting a message asking if they want to enable the macros. I told them changing their macro security would get rid of the message, but that this would have to be done on each pc. Please let me know if there is some way to make the spreadsheet not generate this message other than changing the macro security level. Thanks! Ken K. -- akkrug |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maccro Enabled message
akkrug;392236 Wrote: We set up a spreadsheet that had macros in it. I deleted the macros, but our users are still getting a message asking if they want to enable the macros. I told them changing their macro security would get rid of the message, but that this would have to be done on each pc. Please let me know if there is some way to make the spreadsheet not generate this message other than changing the macro security level. Thanks! Ken K. -- akkrugDelete all macro's and modules, save the workbook re-open and saveas another name....see if that works for you! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109625 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maccro Enabled message
hi
you may have deleted the macros but you didn't delete the module that the macros were in and that is what is generating the message. open the VB editor (Alt+F11). in the project window(far left), expand the project(file). right click module and select "remove module 1". you will get a message asking if you want to save the macro. click no. done. Regards FSt1 "akkrug" wrote: We set up a spreadsheet that had macros in it. I deleted the macros, but our users are still getting a message asking if they want to enable the macros. I told them changing their macro security would get rid of the message, but that this would have to be done on each pc. Please let me know if there is some way to make the spreadsheet not generate this message other than changing the macro security level. Thanks! Ken K. -- akkrug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Enabled workbooks | Excel Discussion (Misc queries) | |||
Macro-enabled workbooks | Excel Discussion (Misc queries) | |||
why is freeze panes not enabled? | Charts and Charting in Excel | |||
AutoFilter is not enabled | Excel Discussion (Misc queries) | |||
Select All enabled | Setting up and Configuration of Excel |