I have a file that I save in .xlt format to make it available for other users
to view easily on our intranet. I would like to add some macros behind the
scences to help me update the file easily. Is there a way to save the file
for other users that will disable the macros from running and not give the
msg box when opening the file asking you to enable or disable macros?

Thanks for the help.

Put your macros in another file, such as Personal.xls, and address the
template specifically. Don't add them to the template.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
I have a file that I save in .xlt format to make it available for other
users
to view easily on our intranet. I would like to add some macros behind
the
scences to help me update the file easily. Is there a way to save the
file
for other users that will disable the macros from running and not give the
msg box when opening the file asking you to enable or disable macros?

Thanks for the help.

i'm not sure about putting the actual coding itself but you can export
(file/export)your macro on your hard drive somewhere and then delete
the macro from the xl save file. However, you need to open the macro
everytime you open the file but others cannot use the macro since they
don't access to it

hope that helps


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=389033

Thanks for both of the replies

"narutard" wrote:


i'm not sure about putting the actual coding itself but you can export
(file/export)your macro on your hard drive somewhere and then delete
the macro from the xl save file. However, you need to open the macro
everytime you open the file but others cannot use the macro since they
don't access to it

hope that helps


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=389033

Similar to Bob Phillip's suggestion about personal.xls, put the macros
in a separate workbook. For example, if your template is called "our
template.xlt" create another workbook "our template maintenance
macros.xls" and put the macros in there. Put both the files in some
folder and it will be obvious what files go with what other files.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a file that I save in .xlt format to make it available for other users
to view easily on our intranet. I would like to add some macros behind the
scences to help me update the file easily. Is there a way to save the file
for other users that will disable the macros from running and not give the
msg box when opening the file asking you to enable or disable macros?

Thanks for the help.