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

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.
 
D

Dave Peterson

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.
 

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

Unshare a Shared Workbook 1
Auto Filter - Protected sheet/workbook 3
Programatically filter a protected shared workbook 4
Run a sort macro in a protected WORKBOOK 4
using autofilter in a shared protected workbook excel 2000? 1
Filtering a protected WS in a shared workbook - Excel 2000 3
Pls help on Shared WorkBook 1
Programatically Filter a protected shared worksheet 1

Top