How do I give permission for certain functions in excel in locked.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have locked all of a worksheet, except for a data entry portion. During
the locking proceedure, excel appears to give options for allowing the user
permission to use certain functions while the worksheet is locked, such as
"sort". However, that is not being allowed. Any ideas?
 

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

Protecting Excel Formulas 2
Allowing editing locked cells in a protected sheet in excel 1
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? 1
How do I allow data entry to one column only? 2
Locking documents in Excel after a template has been created. 2
Sorting a Spreadsheet with locked cells 1
Can a row containing protected & unprotected cells be copied? 8
Formatting of cells in a locked worksheet. EG shading 1

Back
Top