MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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...

Posted by JohnG on February 15, 2002 11:15 AM

You could try putting in a check to see whick directory its in and if its in the archive directory to exit the sub