ExcelBanter - Can I sort a table using a macro in a protected worksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can I sort a table using a macro in a protected worksheet? (https://www.excelbanter.com/excel-programming/331264-can-i-sort-table-using-macro-protected-worksheet.html)

Edgar[_2_]

Can I sort a table using a macro in a protected worksheet?

I got this message: "Sort method of Range Class failed". What can I do?

Thanks

Edgar

Tom Ogilvy

Can I sort a table using a macro in a protected worksheet?

Set up the sort command so that it properly references the correct
locations.

--
Regards,
Tom Ogilvy

"Edgar" wrote in message
...
I got this message: "Sort method of Range Class failed". What can I do?

Thanks

Edgar

All times are GMT +1. The time now is 05:47 PM.