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
 
Back
Top