I have a template that people will use to create many excel sheets
from.

When the template opens, it asks you if you want to enable macros.
This message I can deal with.

I want to know if there is some way once the new excel sheet is made
from the template, that the enable macros dialog can be disabled?

I do not think I can just use Application.DisplayAlerts = false because
I do not want to shut it off for all of excel, just for that individual
workbook.

Thanks


--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=389885