Turn off macros when opening a workbook

vectorges · May 15th, 2002, 09:08 AM

I plagiarized a macro fom this site to open a set of workbooks. When I run it I get the ubiquitous 1004 error message. I am trying to open a set of TSP workbooks that have some automatic macros. If I change teh macro to open a set of more normal workbooks, it works fine. I think it has to do with the open command trying to ask a question about "Do you want to enable macros?".

Does anyone have any ideas on a property to set to eliminate this question??

kkknie · May 15th, 2002, 09:15 AM

The only way I know to do this is to set your macro security to Low (Tools | Macros | Security). If there were a way set up a workbook to not ask this question, it would defeat the whole purpose of asking it (which is to disable a macro virus).

K

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 09:08 AM	#1
vectorges New Member Join Date: Mar 2002 Location: George Posts: 4	I plagiarized a macro fom this site to open a set of workbooks. When I run it I get the ubiquitous 1004 error message. I am trying to open a set of TSP workbooks that have some automatic macros. If I change teh macro to open a set of more normal workbooks, it works fine. I think it has to do with the open command trying to ask a question about "Do you want to enable macros?". Does anyone have any ideas on a property to set to eliminate this question??

May 15th, 2002, 09:15 AM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	The only way I know to do this is to set your macro security to Low (Tools \| Macros \| Security). If there were a way set up a workbook to not ask this question, it would defeat the whole purpose of asking it (which is to disable a macro virus). K