I have been playing around with excels protect sheet functions but cannot get the level of protection i would like.
I simply wish to protect the formula within some columns. But i would still like users to be able to format (fill colour, border, font), copy, change cell size, hide group, show group.
The main 2 i am having problems with is hide/unhide group and insert row.
Is this possible or is it all or nothing when it comes to protection?
Thanks for any help.
Bookmarks