Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AUTOSORTING | Excel Discussion (Misc queries) | |||
Need help autosorting information into different cells | Excel Discussion (Misc queries) | |||
Autosorting Information | Excel Worksheet Functions | |||
autosorting to a leaderboard | Excel Discussion (Misc queries) | |||
Autosorting and working out medalists for data. | Excel Programming |