How to Activate "Show all" in a Protected Shared Workbook

  • Thread starter Thread starter Anahid
  • Start date Start date
A

Anahid

Hi,

I created a protected and shared workbook in Excel 2003 ,the default
Filter Option is "Auto Filter"

how can I use the "Show All" in Filtering.?

even I unchecked the "Filter Settings" in "Tools-> Share Workbook ->
Advanced -> Include Personal View " but it did not work.

Thanks.
 
You can't.

If the workbook were not shared, then you could create your own macro that
unprotects the worksheet, does the showall and reprotects the worksheet.

But with the workbook shared, you can't change the protection of a sheet.
 
Back
Top