Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have set up a workbook that protects and unprotects every sheet in the
workbook with the following macros: (My problem is that I want to allow the user to enter comments into the protected worksheets and I can't figure out how to get the protection macro to allow this.) I know it has something to do with "drawingobjects=false", but I can't squeeze it in.--------Please Help: Sub protect_sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="****" Next ws ' End Sub Sub Unprotect_sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Unprotect Password:="****" Next ws ' End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clear Macro & Password Protection | Excel Discussion (Misc queries) | |||
use a macro to automate excel worksheet password protection | Excel Discussion (Misc queries) | |||
develop a macro which takes password protection on and off | Excel Discussion (Misc queries) | |||
Password protection | Excel Discussion (Misc queries) | |||
Password Protection | Excel Discussion (Misc queries) |