Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ARSmythe
 
Posts: n/a
Default How do I stop Excel from prompting to enable or disable macros?

My file used to have several Macros, but I've deleted all of them (using
Tools-Macros-All Open Workbooks). However, users of this file are still
prompted at the beginning to enable/disable the macros. I need to eliminate
this step. Thanks in advance for your assistance.

Adam
Excel 2000
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Delete all standard modules.

HTH
Jason
Atlanta, GA

-----Original Message-----
My file used to have several Macros, but I've deleted

all of them (using
Tools-Macros-All Open Workbooks). However, users of

this file are still
prompted at the beginning to enable/disable the macros.

I need to eliminate
this step. Thanks in advance for your assistance.

Adam
Excel 2000
.

  #3   Report Post  
ARSmythe
 
Posts: n/a
Default

What else is classified as a "standard module"? Is there an easy way to
identify?

Thanks.

"Jason Morin" wrote:

Delete all standard modules.

HTH
Jason
Atlanta, GA

-----Original Message-----
My file used to have several Macros, but I've deleted

all of them (using
Tools-Macros-All Open Workbooks). However, users of

this file are still
prompted at the beginning to enable/disable the macros.

I need to eliminate
this step. Thanks in advance for your assistance.

Adam
Excel 2000
.


  #4   Report Post  
Ken Wright
 
Posts: n/a
Default

You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane
you need to search for
your workbook's name, and when you find it you may need to click on the + 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
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets
above as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question
re exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the
file.


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"ARSmythe" wrote in message
...
My file used to have several Macros, but I've deleted all of them (using
Tools-Macros-All Open Workbooks). However, users of this file are still
prompted at the beginning to enable/disable the macros. I need to

eliminate
this step. Thanks in advance for your assistance.

Adam
Excel 2000



  #5   Report Post  
ARSmythe
 
Posts: n/a
Default

That worked. Thanks for your help.

Adam


"Ken Wright" wrote:

You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane
you need to search for
your workbook's name, and when you find it you may need to click on the + 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
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets
above as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question
re exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the
file.


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"ARSmythe" wrote in message
...
My file used to have several Macros, but I've deleted all of them (using
Tools-Macros-All Open Workbooks). However, users of this file are still
prompted at the beginning to enable/disable the macros. I need to

eliminate
this step. Thanks in advance for your assistance.

Adam
Excel 2000




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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 05:08 PM
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 01:24 AM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 05:06 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 03:31 PM


All times are GMT +1. The time now is 02:19 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"