Don't show "enable macros" on opening of workbook

Mark N. · Mar 15th, 2002, 03:03 PM

Is there some code I can add to the workbook that will prevent the user from having to click on "enable macros" when they open the workbook? Can it be bypassed on a single workbook but left intact for other workbooks?

Mark O'Brien · Mar 15th, 2002, 03:05 PM

Have a look at these fun threads:

http://www.mrexcel.com/board/viewtop...c=2092&forum=2
http://www.mrexcel.com/board/viewtop...c=2434&forum=2

Mar 15th, 2002, 03:05 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have a look at these fun threads: http://www.mrexcel.com/board/viewtop...c=2092&forum=2 http://www.mrexcel.com/board/viewtop...c=2434&forum=2 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Mar 15th, 2002, 03:03 PM	#1
Mark N. New Member Join Date: Mar 2002 Location: Virgina, USA Posts: 1	Is there some code I can add to the workbook that will prevent the user from having to click on "enable macros" when they open the workbook? Can it be bypassed on a single workbook but left intact for other workbooks?