using a macro to unproctect a password protected sheet
 

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

using a macro to unproctect a password protected sheet
 

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


"paul d" wrote in message
...
Is it possible to unprotect a sheet using a macro then
manipulate data in the sheet and then repassword protect in the
same macro

using a macro to unproctect a password protected sheet
 

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



On Wed, 11 Feb 2004 16:31:05 -0800, paul d
wrote:

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

using a macro to unproctect a password protected sheet
 

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


"paul d" wrote in messag
..
Is it possible to unprotect a sheet using a macro the
manipulate data in the sheet and then repassword protect in th
same macr

using a macro to unproctect a password protected sheet
 

thank you so much works perfectly