Protect a maco in master copy
I have a macro that is run in a workbook that is the master copy.
When the macro runs I have the user enter a new name to save the file. Once this happens the original macro is transferred to the new file, is there a way to protect this code so that it stays in the master copy and also transfers to the new workbook as well? |
Protect a maco in master copy
The key is where the macro lives. If it's in the master workbook, and that workbook is
saved, the macro will also live in the saved workbook. It the macro is in another workbook (Personal.xls, or any other workbook), it won't be saved. -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome. ----------------------------------------------------------------------- wrote in message ups.com... I have a macro that is run in a workbook that is the master copy. When the macro runs I have the user enter a new name to save the file. Once this happens the original macro is transferred to the new file, is there a way to protect this code so that it stays in the master copy and also transfers to the new workbook as well? |
Protect a maco in master copy
That's what's happening now, unless the macro specifically deletes the
code in the template. If that code exists, delete it. In article . com, wrote: I have a macro that is run in a workbook that is the master copy. When the macro runs I have the user enter a new name to save the file. Once this happens the original macro is transferred to the new file, is there a way to protect this code so that it stays in the master copy and also transfers to the new workbook as well? |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com