Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop running macros everytime I run excel?
Hi I need help I am taking an Excel class where they are teaching us to run
macros but now every time I open Excel the macros that I created keeps popping up on the workbook I tried deleting it but it deleted it from the list in the macros dialog box and it still keeps showing up. Can anyone help me please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop running macros everytime I run excel?
---If you are looking to disable macros; set the security setting to high.
from menu ToolsMacrosSecurity. ---If you are looking to disable the macros which run during file open then hold down the SHIFT key when you open the workbook. Please note that this will work only when you open the workbook through FileOpen menu within Excel application. ---If you want to remove all macros from workbook press Alt+F11 and to launch VBE (Visual Basic Editor). From the left treeview search for the workbook name and click on + to expand it. Within that you should see the following VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 Right click on the modules and select remove. When prompted with a question to export; hit no. Then hit File/Close and return to Microsoft Excel and save the file. If this post helps click Yes --------------- Jacob Skaria "SusieOrtiz" wrote: Hi I need help I am taking an Excel class where they are teaching us to run macros but now every time I open Excel the macros that I created keeps popping up on the workbook I tried deleting it but it deleted it from the list in the macros dialog box and it still keeps showing up. Can anyone help me please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel from opening all files w/macros & running them | Excel Discussion (Misc queries) | |||
running excel 2003 macros | Excel Discussion (Misc queries) | |||
Macros available everytime | Excel Discussion (Misc queries) | |||
How do I stop dates from being entered everytime I enter a number | Excel Discussion (Misc queries) | |||
How do I stop spanner from running in Excel. | Excel Discussion (Misc queries) |