How to stop running macros everytime I run excel?

S

SusieOrtiz

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?
 
J

Jacob Skaria

---If you are looking to disable macros; set the security setting to high.
from menu Tools>Macros>Security.

---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 File>Open 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top