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

Good afternoon reddog9069

There are three ways of dealing with this.

(i) Have the person who designed the template set themselves up with
digital certificate (you probably don't want this one)

(ii) Set your Excel security to Low (you don't want this one either).

(iii) Delete the macros : if you are not going to use the macros, thi
is your best option. If you can't do it by hand download the ASA
Utilities free add-in (www.asap-utilities.com) which has a utility tha
will do this for you.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38988

A long shot -

Build an add-in with code not needed in the add-in.
Include code to open the template.

You should be able to set the code to open the template
and disable macros.

If you can do this - than you will have turned off all the alerts...

--
steveB

Remove "AYN" from email to respond
"reddog9069" wrote
in message ...

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

Hmmm....

I still need the macros to work after they have been saved as
worksheet from the template.

Now that I think about it, if it was possible to do, then people tryin
to delete all your word files would have an easy time because they coul
disable the prompt.

I am going to have to find a way to get a digital certificate mos
likely

--
reddog906
-----------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...fo&userid=2445
View this thread: http://www.excelforum.com/showthread.php?threadid=38988

Hi reddog9069

...either that or just put up with the warning dialog!

DominicB


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