| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect workbook when saving
Hi,
I have a macro below that needs recoded as it's not working, I am looking for the macro so when I press the save button it automatically protects all the worksheets in the workbook. Private Sub Workbook_BeforeClose(Cancel As Boolean) ProtectAllSheets.protect Password:="ABCD" End With Application.EnableEvents = False ThisWorkbook.Save Application.EnableEvents = True End Sub Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Disable Tools, Protect, Protect Workbook | Excel Programming | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
Threaded Mode
