Hi all

i have a sheet i have protected, but i have only locked some cells due to the fact there is very important formulas in them that i cant have users overwriting, and some cells users need to be able to write into.

But..... i have sections grouped as it doesnt need to be seen, but should the user need to see them then i need them to be able to ungroup them

i have looked on what you can and cant select when protecting a sheet, and cant see anything for grouping, i have checked select locked cells, select unlocked cells, and auto filter which are all vital to the sheet

I found this code

Please Login or Register  to view this content.
But this then locks all cells, and doesnt allow auto filter, is there a module that can allow ungrouping, or do i need to change Contents to false or Userinterfaceonly to false?

Thanks

Dan