Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining a worksheet's protection status in VBA
What would be the syntax for finding out protection status of activeworkbook.sheets("MySheet") in VBA ? -- -regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining a worksheet's protection status in VBA
MsgBox ActiveWorkbook.Sheets("Sheet1").ProtectContents
-- HTH... Jim Thomlinson "GeorgeJ" wrote: What would be the syntax for finding out protection status of activeworkbook.sheets("MySheet") in VBA ? -- -regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining a worksheet's protection status in VBA
Thanks Jim, that was just what I needed.
-regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection status | Excel Worksheet Functions | |||
Worksheet protection status | Excel Discussion (Misc queries) | |||
Display worksheet protection status in a cell? | Excel Worksheet Functions | |||
Sheet Protection Status | Excel Worksheet Functions | |||
Cell to equal a worksheet's name | Excel Discussion (Misc queries) |