Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Activate "Show all" in a Protected Shared Workbook
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Activate "Show all" in a Protected Shared Workbook
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. Anahid wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbook is "locked for editing" | Excel Worksheet Functions | |||
Autofilter set to "SHOW ALL" on open for a protected worksheet | Excel Discussion (Misc queries) | |||
"Shared Workbook" seems to deactivate features like macros | Excel Discussion (Misc queries) | |||
Password-Protected Workbook not showing "in use by another user" | Excel Discussion (Misc queries) | |||
"Show all" button not work in protected worksheet | Excel Worksheet Functions |