Excel 2002 "Protect Sheet", but allow "Hide Columns"?

V

VP Safe

When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
formulas from being deleted. Prior to turning on protection I unlocked the
cells that I wanted users to be able to edit. And I have checked the box to
"Allow all users of this worksheet to:" "Delete Columns".

What I *don't* see on the "Protect Sheet" menu is an option to "Hide Columns"

Do you know of any way that I can allow users to do this, without turning
off the protection in MS Excel 2002?
 
D

Dave Peterson

But there is an option to Format Columns.

(and hiding the column is a format change.)
 

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

Similar Threads

hide columns on a protected sheet 2
hide columns on a protected sheet??? 1
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? 2
Protect and Edit Object 1
Protect Sheet - But have button to add more lines 1
Sheet Protection / Edit Objects 0
Protect Sheet but allow pictures 4
How can i protect a formula and still allow copy and move data? 1

Top