Thread: Locked Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_4_] Gaurav[_4_] is offline
external usenet poster
 
Posts: 36
Default Locked Cells

Select the cell, go to Data Validation. and check whats there.


"PAL" wrote in message
...
I have been using an excel file for a few weeks with no issues, all of a
sudden I am getting an error message: The value you entered is not valid.
A
user has restricted values that can be put into this cell. Retry. Cancel.

I started this workbook, I have done a fair amount of copy pasting into
it.
With no issues. How do I unprotect. Please advise.

Microsoft 2002 is in use here.

Thanks.