View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default hide columns on a protected sheet???

Check "Format Columns" option "under allow users to"


Gord Dibben MS Excel MVP

On Thu, 21 Jan 2010 15:44:02 -0800, Rose
wrote:

When using MS Excel 2003: 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 2003?