View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dr chuck dr chuck is offline
external usenet poster
 
Posts: 74
Default 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