Can I disable macros in archived workbooks
Posted by Sam Wactor on February 15, 2002 10:43 AM
I have a workbook that I have several macros in. One macro funtion is to save the workbook to two different locations. One location is a archive file. What I need to acomplish is, when the workbook is saved to the archive file it will save the file with all macros disabled. I don't want the file saved as a read only file in case the file needs to be edited.
Thanks for any help...