using a macro to unproctect a password protected sheet

[Guest]

Is it possible to unprotect a sheet using a macro then manipulate data in the sheet and then repassword protect in the same macro

 

[Chip Pearson]

Paul,

Try something like

Worksheets("Sheet1").Unprotect password:="whatever"
' your code here
Worksheets("Sheet1").Protect password:="whatever"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Is it possible to unprotect a sheet using a macro then

manipulate data in the sheet and then repassword protect in the
same macro

 

[Gord Dibben]

Paul

Yes it is.

Assuming the sheet has been previously protected with a password

Sub Test()
ActiveSheet.Unprotect Password:="password"

'do your manipulation steps here

ActiveSheet.Protect Password:="password", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

End Sub

Gord Dibben Excel MVP

 

[Guest]

You're a lifesaver works perfectl
----- Chip Pearson wrote: ----

Paul

Try something lik

Worksheets("Sheet1").Unprotect password:="whatever
' your code her
Worksheets("Sheet1").Protect password:="whatever


--
Cordially
Chip Pearso
Microsoft MVP - Exce
Pearson Software Consulting, LL
www.cpearson.co

Is it possible to unprotect a sheet using a macro the

manipulate data in the sheet and then repassword protect in th
same macr

 

[Guest]

thank you so much works perfectly