V
Visakha
Hello. I am currently using the following macro:
Option Explicit
Sub UnprotectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.unprotect password:="topsecret"
next wks
End Sub
Sub ProtectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="topsecret"
next wks
End Sub
I would like to be able to modify this macro so that end users can format
rows as needed. I am a beginnner macro user. Thanks in advance!
Option Explicit
Sub UnprotectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.unprotect password:="topsecret"
next wks
End Sub
Sub ProtectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="topsecret"
next wks
End Sub
I would like to be able to modify this macro so that end users can format
rows as needed. I am a beginnner macro user. Thanks in advance!