| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting AutoFilter to "Show All" when worksheet is opened
Can someone tell me how to write a macro that will:
1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting AutoFilter to "Show All" when worksheet is opened
What version of Excel are you using? If xl2002 or later, did you look at the
enablefiltering option. -- Regards, Tom Ogilvy "Bob" wrote: Can someone tell me how to write a macro that will: 1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting AutoFilter to "Show All" when worksheet is opened
Tom,
I'm using Excel 2003. I'm not sure I know what you mean by "enablefiltering option". I'm a VBA novice. Regards, Bob "Tom Ogilvy" wrote: What version of Excel are you using? If xl2002 or later, did you look at the enablefiltering option. -- Regards, Tom Ogilvy "Bob" wrote: Can someone tell me how to write a macro that will: 1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting AutoFilter to "Show All" when worksheet is opened
When you first protect the sheet (Tools=Protection=Protect sheet), in the
dialog you have choices to enable, like Select Unlocked cells. On of the choices is Autofilter. You may have to scroll down to see it. Make sure it is checked and see if that works for a shared workbook. -- regards, Tom Ogilvy "Bob" wrote: Tom, I'm using Excel 2003. I'm not sure I know what you mean by "enablefiltering option". I'm a VBA novice. Regards, Bob "Tom Ogilvy" wrote: What version of Excel are you using? If xl2002 or later, did you look at the enablefiltering option. -- Regards, Tom Ogilvy "Bob" wrote: Can someone tell me how to write a macro that will: 1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting AutoFilter to "Show All" when worksheet is opened
Tom,
Yes, I have "Use AutoFilter" checked when I protect the worksheet. But once the worksheet is protected, the "Show All" option under Data | AutoFilter becomes disabled. Hence, the reason why I asked if it could be manipulated via VBA instead. Regards, Bob "Tom Ogilvy" wrote: When you first protect the sheet (Tools=Protection=Protect sheet), in the dialog you have choices to enable, like Select Unlocked cells. On of the choices is Autofilter. You may have to scroll down to see it. Make sure it is checked and see if that works for a shared workbook. -- regards, Tom Ogilvy "Bob" wrote: Tom, I'm using Excel 2003. I'm not sure I know what you mean by "enablefiltering option". I'm a VBA novice. Regards, Bob "Tom Ogilvy" wrote: What version of Excel are you using? If xl2002 or later, did you look at the enablefiltering option. -- Regards, Tom Ogilvy "Bob" wrote: Can someone tell me how to write a macro that will: 1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting AutoFilter to "Show All" when worksheet is opened
I never use shared workbooks, but to the best of my knowledge, that is what
is available to you. If it doesn't work then you may have a problem. Try unlocking all the cells in the workbook, then protect it with your settings and share the workbook. See if it works under those conditions. If it does, then you can try to see if having certain cells locked might contribute to the problem. -- Regards, Tom Ogilvy "Bob" wrote: Tom, Yes, I have "Use AutoFilter" checked when I protect the worksheet. But once the worksheet is protected, the "Show All" option under Data | AutoFilter becomes disabled. Hence, the reason why I asked if it could be manipulated via VBA instead. Regards, Bob "Tom Ogilvy" wrote: When you first protect the sheet (Tools=Protection=Protect sheet), in the dialog you have choices to enable, like Select Unlocked cells. On of the choices is Autofilter. You may have to scroll down to see it. Make sure it is checked and see if that works for a shared workbook. -- regards, Tom Ogilvy "Bob" wrote: Tom, I'm using Excel 2003. I'm not sure I know what you mean by "enablefiltering option". I'm a VBA novice. Regards, Bob "Tom Ogilvy" wrote: What version of Excel are you using? If xl2002 or later, did you look at the enablefiltering option. -- Regards, Tom Ogilvy "Bob" wrote: Can someone tell me how to write a macro that will: 1) automatically run when I open a specific workbook 2) set AutoFilter to "Show All" on the "Summary" worksheet While this may sound easy at first, please note that the aforementioned workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary") is protected. As a result, the "Show All" option within AutoFilter is disabled due to the worksheet being protected. And because the workbook is shared, you can't unprotect the workbook! Any help would be greatly appreciated. Thanks, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter set to "SHOW ALL" on open for a protected worksheet | Excel Discussion (Misc queries) | |||
| Setting values for "TRUE","FALSE" and "#REF!" | Excel Programming | |||
| "trying to access e-mail" when worksheet opened | Excel Programming | |||
| Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
| Setting default "open" worksheet in a workbook | Excel Programming | |||
Hybrid Mode
