Thread: Can I use a Macro to unprotect a sheet in the workbook?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
  
Posts: 300
Default Can I use a Macro to unprotect a sheet in the workbook?
On Wed, 20 Jul 2005, Ron de Bruin wrote:

Try this with the password "ron"

With Sheets("Sheet2")
.Unprotect "ron"
.Rows("10:15").EntireRow.Hidden = True
.Protect "ron"
End With

You can also simplify it to:

With Sheets("Sheet2")
.Protect "ron", UserInterfaceOnly:=True
.Rows("10:15").EntireRow.Hidden = True
End With

Don <www.donwiss.com (e-mail link at home page bottom).
Reply With QuoteReply With Quote