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

Using Filter function with shared workbook 2
Unshare a Shared Workbook 1
Can't seem to delete all images from a Word Doc 2
Troubleshooting shared workbook in Excel 2007 0
Worksheet protected-auto filter works, show all button dosen't. 2
Protect workbook for Windows option is grayed out in Excel 2013 3
Programatically filter a protected shared workbook 4
Excel 2003 - how to check is all worksheet is protected 1

Top