Allow group/ungroup AND format cells

[LHat]

Hi,

I have a number of worksheets that I wish to protect to content of but I also want users to be able to group/ungroup rows and columns as well as format the cells (i.e. change the number of decimal places a number is shown to).

My current code does the following to lock each sheet

ActiveSheet.Protect Password:="Password", DrawingObjects:=False, Contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowFiltering:=True


However I don't seem to be able to add any form of EnableOutlining to this without it refusing to work!
Is there any way to combine the two codes?

[dilipandey]

Hi LHAT,

welcome to the forum.
I don't think Excel will allow decimal place changes after sheet protection.

and for outlining, see below thread:-

http://www.excelforum.com/excel-gene...ted-sheet.html



Regards,
DILIPandey
<click on below * if this helps>

[LHat]

Thanks DILIPandey for your reply! I have managed to allow the decimal place changes just from allowing the formatting of cells.

Is there no way to combine the two pieces of code? (i.e. .EnableOutlining = True and Allowformattingcells:= True)

[dilipandey]

"Outlining" is related to sheet level but "allow formatting cells" is related with sheet's protection option level.

I would say try including both the codes - first the one from the link I given above followed by the one which you shown in post#1.

Regards,
DILIPandey
<click on below * if this helps>

[LHat]

It works!

Thanks for your help

[dilipandey]

Great

Please mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>