| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forgotten Password to Unprotect Workbook/sheet | Excel Discussion (Misc queries) | |||
| Unprotect sheet/workbook | New Users to Excel | |||
| unprotect sheet & workbook dim out | Excel Worksheet Functions | |||
| How to unprotect a workbook by macro? | Excel Discussion (Misc queries) | |||
| Macro to unprotect workbook | Excel Programming | |||
Threaded Mode
