Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop Excel from opening all files w/macros & running them BobC Excel Discussion (Misc queries) 4 April 5th 09 08:25 PM
running excel 2003 macros Terese Excel Discussion (Misc queries) 0 January 25th 08 10:32 PM
Macros available everytime RogueIT Excel Discussion (Misc queries) 3 March 31st 06 12:51 AM
How do I stop dates from being entered everytime I enter a number Kicking and Screaming Excel Discussion (Misc queries) 2 October 23rd 05 02:34 PM
How do I stop spanner from running in Excel. [email protected] Excel Discussion (Misc queries) 1 June 30th 05 07:31 PM


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"