Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Adjusting columns widths while protecting the worksheet

Status
Not open for further replies.

meliorexi

Technical User
Dec 1, 2003
16
AU
Hi

Well the title explains it all really. When I protect the worksheet it's not possible to adjust the column width. Is there any way I can do this?

Thanks

meliorexi
 
Which version of Excel are you using?
In excel 2002 when you protect a sheet you get a selectable list of options a user can/can't perform after you have locked the sheet, and formating columns is part of that.
 
I'm using Excel 2000 which only appears to give you contents, objects and scenarios as things you can select to protect.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top