Hi,
When protecting the sheet you under where you enter the password, there is
an option that says " Allow all users of this worksheet to" there check sort

if this helps please clikc yes, thanks

"Romileyrunner1" wrote:

Hi,
is there a way of allowing all users to sort data using a macro function
(key stroke or linked to an object) whilst having the worksheet protected to
stop formulas ect. being tampered with / ruined!

Thanks!