Open file without macros
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. |
Open file without macros
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. |
Open file without macros
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 |
Open file without macros
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 |
Open file without macros
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. |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com