Is there a way to protect hidden rows and also change fill color?

F

Fan924

I have a sheet protected for contents only. I need this so I can hide
some rows and columns. It is also preventing me from changing fill
color.

Is there a way to protect hidden rows and also change fill color? ...
excel97
 
J

John Bundy

I'm not sure if it works on Excel97 but when you go to protect, there is a
checkbox you can click that still gives them the ability to format cells. If
you need the code for it, just record a macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top