Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am preparing a template where there are few sheets having functionality of grouping and ungrouping of rows. I am using below code for protecting and is working well: Private Sub Worksheet_Activate() With Me ..EnableOutlining = True ..Protect "XXX", UserInterfaceOnly:=True End With End Sub Now in a specific sheet I also want to provide user the ability to change the colour of the specific cells. Please let me know how to update the above code to support the requirement. Any support is much appreciable !!! -Anurag |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I lock specific cells w/o having to protect entire sheet? | Excel Worksheet Functions | |||
To Protect Excel documents and allowing only few cells to edit | Excel Worksheet Functions | |||
After grouping & ungrouping a chart, I can no longer format it? | Charts and Charting in Excel | |||
Slow grouping and ungrouping since update | Excel Discussion (Misc queries) | |||
Protect sheet and allow grouping of columns | Excel Worksheet Functions |