protecting a sheet
 

please help. is it possible to password protect only one sheet in workbook?
if so, could anyone please help. can i incorporate the script into an
existing macro?
thanks

protecting a sheet
 

Try this

Sub Sonic()
'Do lots of things
Sheets("Sheet1").Protect Password:="Mypass"
End Sub

Mike

"des-sa" wrote:

please help. is it possible to password protect only one sheet in workbook?
if so, could anyone please help. can i incorporate the script into an
existing macro?
thanks

protecting a sheet
 

Sub Macro1()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

--
Gary''s Student - gsnu200827


"des-sa" wrote:

please help. is it possible to password protect only one sheet in workbook?
if so, could anyone please help. can i incorporate the script into an
existing macro?
thanks

protecting a sheet
 

From XL
Tools-Protection-Protect sheet

From VBA (w/ password)
Sub test()
Dim xPass As String
xPass = "MyPassword"
ActiveSheet.Protect Password = xPass
ActiveSheet.Unprotect Password = xPass
End Sub

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"des-sa" wrote:

please help. is it possible to password protect only one sheet in workbook?
if so, could anyone please help. can i incorporate the script into an
existing macro?
thanks