Sorting Data in Protected Sheet

  • Thread starter Thread starter Akbar Merchant
  • Start date Start date
A

Akbar Merchant

Hi

I will be glad if you guys can help me out.My problem is
that I created a Protected Sheet other function like
Sorting doesn't work if i want to sort the data according
to the date(mth/yr) or by the Project managers I can't.

Can you suggest me any solutions .ok

Thanks

With Regards


Akbar Merchant
 
A protected sheet is just that. You can't make any changes to the locked
cells. You will have to unprotect the sheet to make any changes. If you
are doing things to the sheet via VBA then you can add code to unprotect the
sheet and reprotect it when you are through. HTH Otto
 
You must log in or register to reply here.

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

Sorting in a protected sheet 1
Sorting data in protected sheets? 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Sort Protect Sheet 1
Sorting Text Data 4
Excell /office 2003 Data Sorting 3
Sort Contiguous Columns - Danger 3
Protect Data, but allow sorting 4

Back
Top