View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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?