ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locked Cells (https://www.excelbanter.com/excel-worksheet-functions/205430-locked-cells.html)

PAL

Locked Cells
 
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.

Gaurav[_4_]

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.





All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com