Gaining Access to Restricted Cells on Spreadsheet

**phaiz_nova87** · 09-07-2010, 08:13 AM

Hi guys,

I happened to come across a post on purchase order from excelforum.com and I am very delighted to see such a robust and practical PO.

Credit to Norman May for sharing such a good piece of work, however there is a question I would like to ask regarding the "History" sheet.

Is there a way to unrestrict the top most cells of the sheet, where it holds the label for the data? I would like to add/change the title accordingly. I have tried modifying the codes for it but it didn't work, it keeps gving the "The value you entered is not valid, a user has restricted the values that can be entered into this cell"

As attached is the Purchase Order.

Thanks alot in advance,
Faiz

**NBVC** · 09-07-2010, 08:20 AM

Norman has added data validation to those cells

Select the cell(s) and go to Data|Validation and select "Any Value" from the drop down menu.

**phaiz_nova87** · 09-07-2010, 10:49 AM

Thanks a lot for the reply, NVBC

Would it somehow change any codes assign to it or the macro in any way having made the change to Data Validation?

**NBVC** · 09-07-2010, 10:58 AM

It shouldn't. Data Validation is based on physically manually entering data into the cell... If you enter data by copy/pasting or using VBA onto those cells, then the Data Validation is ignored anyway....