I have a shared work sheet that has many columns and have found that when I
proctect the sheet so that certain cells can not be changed I lose the
ablitiy to hide/unhide and and select all under auto filter. Any suggestions?

Pattie,
If by shared workbook you mean TOOLSSHARE WORKBOOK the following
restrictions are in place for a shared workbook:

You won't be able to add or change the following: merged cells,
conditional formats, data validation, charts, pictures, objects
including drawing objects, hyperlinks, scenarios, outlines, subtotals,
data tables, PivotTable reports, workbook and worksheet protection, and
macros.

If you also Protect a worksheet TOOLSPROTECTION additional
restrictions to changes on the worksheet are present. For additional
insight into worksheet and workbook protection type: "About worksheet
and workbook protection" into Help.

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=559371