ActiveWorkbook.Save

Macro 4: Protect a Worksheet on Workbook Close Sometimes you need to send your workbook out into the world with specific worksheets protected. If you find that you’re constantly protecting and unprotecting sheets before distributing your work- books, this macro can help you. How it works This code is triggered by the workbook’s BeforeClose event. […]