autosorting protected data with macros
 

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

autosorting protected data with macros
 

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

autosorting protected data with macros
 

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

autosorting protected data with macros
 

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?

autosorting protected data with macros
 

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?