I have a set of data that i share with other users and allow them to autosort
through. The data is protected so that the other users cannot corrupt the
data.

I recently wrote some macros that include detailed multilevel autosorts of
the same data. i wrote and tested the macros with no protection and they
function well.

When i reprotect my data and then attempt to run my macro i get a run time
error telling me i cannot do an autosort on a protected sheet on lines like
the one below...

Selection.AutoFilter Field:=8, Criteria1:="0"

Any suggestions ???

--
dr chuck

chuck

See Debra Dalgleish's site for info on why you can't create an autofilter on a
protected sheet.

Also a couple of work-arounds to allow it.

http://www.contextures.com/xlautofilter03.html#Protect




On Sun, 18 Jun 2006 17:23:01 -0700, dr chuck
wrote:

I have a set of data that i share with other users and allow them to autosort
through. The data is protected so that the other users cannot corrupt the
data.

I recently wrote some macros that include detailed multilevel autosorts of
the same data. i wrote and tested the macros with no protection and they
function well.

When i reprotect my data and then attempt to run my macro i get a run time
error telling me i cannot do an autosort on a protected sheet on lines like
the one below...

Selection.AutoFilter Field:=8, Criteria1:="0"

Any suggestions ???

Gord Dibben MS Excel MVP

thanks will check it out....
Wonder if i had my macro turn off the protection when it filtered and then
turn it back on after filter if that would resolve my data protection issues?
--
dr chuck


"Gord Dibben" wrote:

chuck

See Debra Dalgleish's site for info on why you can't create an autofilter on a
protected sheet.

Also a couple of work-arounds to allow it.

http://www.contextures.com/xlautofilter03.html#Protect




On Sun, 18 Jun 2006 17:23:01 -0700, dr chuck
wrote:

I have a set of data that i share with other users and allow them to autosort
through. The data is protected so that the other users cannot corrupt the
data.

I recently wrote some macros that include detailed multilevel autosorts of
the same data. i wrote and tested the macros with no protection and they
function well.

When i reprotect my data and then attempt to run my macro i get a run time
error telling me i cannot do an autosort on a protected sheet on lines like
the one below...

Selection.AutoFilter Field:=8, Criteria1:="0"

Any suggestions ???

Gord Dibben MS Excel MVP

Yes. That would be another method.

Sub Do_Stuff()
ActiveSheet.Unprotect Password:="justme"

'your code here

ActiveSheet.Protect Password:="justme"
End Sub


Gord


On Mon, 19 Jun 2006 08:12:02 -0700, dr chuck
wrote:

thanks will check it out....
Wonder if i had my macro turn off the protection when it filtered and then
turn it back on after filter if that would resolve my data protection issues?

thanks gord
--
dr chuck


"Gord Dibben" wrote:

Yes. That would be another method.

Sub Do_Stuff()
ActiveSheet.Unprotect Password:="justme"

'your code here

ActiveSheet.Protect Password:="justme"
End Sub


Gord


On Mon, 19 Jun 2006 08:12:02 -0700, dr chuck
wrote:

thanks will check it out....
Wonder if i had my macro turn off the protection when it filtered and then
turn it back on after filter if that would resolve my data protection issues?