T
Tanya
I have a sheet with a range A6:BP6 and I want to be able to sort by column
after a message prompt to select the column to sort by. Is this possible?
I have tried autofilter and it and found I needed to unlock the workbook
before accessing this feature, furthermore, for some reason it wouldn't sort
1-20 correctly, instead it started sorting from 10. Perhaps there is a
problem with the workbook?
Anyway it would be helpful if I could use a command button to run a macro
for this task. I already have a macro called Protect and another called
UnProtect to get around the locked workbook.
Any assistance would be appreciated.
Regards
Tanya
after a message prompt to select the column to sort by. Is this possible?
I have tried autofilter and it and found I needed to unlock the workbook
before accessing this feature, furthermore, for some reason it wouldn't sort
1-20 correctly, instead it started sorting from 10. Perhaps there is a
problem with the workbook?
Anyway it would be helpful if I could use a command button to run a macro
for this task. I already have a macro called Protect and another called
UnProtect to get around the locked workbook.
Any assistance would be appreciated.
Regards
Tanya