allowing sort in protected worksheet

R

rohit

I have a protected ws. How can allow a table with 4 columns to be sorted
alphabetically w/o unprotecting the ws?
 
J

JLatham

You have 2 choices:
1) Unprotect the sheet then change the Security for those 4 columns (via
Format --> Cells --> [Protection] and clearing the "Locked" box for them.
Then put your sheet back into protection mode with the option to permit
sorting still selected.

2) Use a VBA solution that would unprotect the sheet, perform the sort, put
the sheet back into protected mode.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort multiple columns on all worksheets 2
password protection macro - HELP???? 4
Grouping with protected sheets (multiple sheets) 0
Cell Protection? 2
how to sort in a protected worksheet. 17
Inserting a comment box in a protected worksheet 2
Run a sort macro in a protected WORKBOOK 4
How to call a worksheet (as a function) 18

Top