Alaska Software Inc. - Excel -- How to "Enable AutoFilter functionality for a protected worksheet" in xbase++.
Username: Password:
AuthorTopic: Excel -- How to "Enable AutoFilter functionality for a protected worksheet" in xbase++.
Robert TinExcel -- How to "Enable AutoFilter functionality for a protected worksheet" in xbase++.
on Sun, 14 Feb 2010 16:00:46 +0800
Hi,

How to "Enable AutoFilter functionality for a protected worksheet" in
xbase++. I have used following statement but it does not work.

oSheet02:EnableAutoFilter := .t.
oSheet02:Protect( "testpw" )

The protected worksheet always has "Disable AutoFilter Function'.

Thanks,
Robert
Ronald van Veelen Re: Excel -- How to "Enable AutoFilter functionality for a protected worksheet" in xbase++.
on Tue, 16 Feb 2010 15:33:11 +0100
Op Sun, 14 Feb 2010 16:00:46 +0800 schreef Robert Tin:

> Hi,
> 
> How to "Enable AutoFilter functionality for a protected worksheet" in
> xbase++. I have used following statement but it does not work.
> 
> oSheet02:EnableAutoFilter := .t.
> oSheet02:Protect( "testpw" )
> 
> The protected worksheet always has "Disable AutoFilter Function'.
> 
> Thanks,
> Robert

Hi Robert,

My guess would be the other way around. First remove the protection with
the pw and then change properties/values.

Good luck