2003, 2007

Why does Autofilter not work on a protected w/s even when "checked to allow" ??

On the particular w/s, I checked the dialog box to allow Autofilter.

Further, I used the following VBA resulting with the same problem:

Sub workbook_open()
With Worksheets("My Sheet Name")
.Protect , userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With

NOTE: If I unprotect the w/s, I can toggle autofilter.

BTW, the workbook in question is saved as 2003 with 2007.

Any thoughts appreciated.

EagleOne

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.

I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




wrote in message ...
2003, 2007

Why does Autofilter not work on a protected w/s even when "checked to allow" ??

On the particular w/s, I checked the dialog box to allow Autofilter.

Further, I used the following VBA resulting with the same problem:

Sub workbook_open()
With Worksheets("My Sheet Name")
.Protect , userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With

NOTE: If I unprotect the w/s, I can toggle autofilter.

BTW, the workbook in question is saved as 2003 with 2007.

Any thoughts appreciated.

EagleOne

Good question Ron!

Well, the answer is "same problem!" on both the 2003 & 2007 installs.

I even selected all "Allow User To" boxes on the 2003 machine.
Then I saved the file after selecting the boxes to ascertain if that
would make any difference, it did not.

EagleOne

"Ron de Bruin" wrote:

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.

I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?

Can you send me your test file private so I can see if I can reproduce it

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




wrote in message ...
Good question Ron!

Well, the answer is "same problem!" on both the 2003 & 2007 installs.

I even selected all "Allow User To" boxes on the 2003 machine.
Then I saved the file after selecting the boxes to ascertain if that
would make any difference, it did not.

EagleOne

"Ron de Bruin" wrote:

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.

I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?

You must be in filter mode before protecting the sheet with "allow user to",
then autofilter will be allowed.


Gord Dibben MS Excel MVP

On Mon, 13 Apr 2009 12:53:32 -0400,
wrote:

Good question Ron!

Well, the answer is "same problem!" on both the 2003 & 2007 installs.

I even selected all "Allow User To" boxes on the 2003 machine.
Then I saved the file after selecting the boxes to ascertain if that
would make any difference, it did not.

EagleOne

"Ron de Bruin" wrote:

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.

I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?

Gord,

Excellent! I misunderstood what "Allow user to filter" meant.
If I initiate Autofilter before protecting the w/s then the user can use the autofilter.

I had assumed that any user wold be allowed to apply and unapply the filtermode
on any protected w/s.

My expectation was in error.


Gord Dibben <gorddibbATshawDOTca wrote:

You must be in filter mode before protecting the sheet with "allow user to",
then autofilter will be allowed.


Gord Dibben MS Excel MVP

On Mon, 13 Apr 2009 12:53:32 -0400,
wrote:

Good question Ron!

Well, the answer is "same problem!" on both the 2003 & 2007 installs.

I even selected all "Allow User To" boxes on the 2003 machine.
Then I saved the file after selecting the boxes to ascertain if that
would make any difference, it did not.

EagleOne

"Ron de Bruin" wrote:

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.

I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?

Thanks for "stopping by." Gord nailed the answer.

I had a bad assumption as to the user being able to apply/unapply autofilter.
The allowance of use was for just using the autofilter, only if, initiated before the protection is
applied.

"Ron de Bruin" wrote:

Can you send me your test file private so I can see if I can reproduce it