Learn

ActiveWorkbook.Save

Macro 4: Protect a Worksheet on Workbook Close

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. […]

Macro 4: Protect a Worksheet on Workbook Close Read More »

Macro 2: Saving a Workbook

Macro 2: Saving a Workbook When a Particular Cell Is Changed Sometimes, you may be working on data that is so sensitive that you’ll want to save every time a par- ticular cell or range of cells is changed. This macro allows you to define the range of cells that, when changed, forces the workbook

Macro 2: Saving a Workbook Read More »

Share knowledge