LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open and copy all workbook sheets in a folder to a master file [email protected] Excel Discussion (Misc queries) 0 November 2nd 06 04:29 PM
I have a master spreadsheet, how do I create a copy? Kat Excel Worksheet Functions 2 October 29th 06 08:21 AM
macro security warning when no maco in workbook Nuts Excel Discussion (Misc queries) 1 March 28th 06 11:21 AM
Is there any way to have a maco click a command button ChairMan Excel Discussion (Misc queries) 0 March 23rd 06 03:58 PM
A simple maco . . . Steve New Users to Excel 3 January 2nd 05 10:36 PM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"