Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a sheet which I need to protect:
I have this code (VBA) With ActiveSheet .Protect Password:="xxx" .EnableSelection = xlUnlockedCells End With AND it works great. BUT I need to add to this so they cab use FormatCells, FormatColumns and FormatRows. When I wrote this: With ActiveSheet .Protect Password:="xxx" .EnableSelection = xlUnlockedCells .EnableSelection = xlFormatCells .EnableSelection = xlFormatColumns .EnableSelection = xlFormatRows End With IT DOES NOT WORK. Am I doing the code wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Question about protecting | New Users to Excel | |||
Question about protecting a formula. | Excel Discussion (Misc queries) | |||
Question about protecting charts | Excel Discussion (Misc queries) | |||
A question about locking or protecting a worksheet | Excel Discussion (Misc queries) |