The Lemon Fool

Hi Itsallaguess and kiloran

I would really like to make a copy of the Hyptuss with no validation, so that I can modify some of the formulae.

It seems that I need to enter a password to remove the data validation, but this is not the expected "pleaseletmein".

I know it's dangerous, but I would really like to set up my own tables that just do lookups on the latest version next time it has to change.

Thanks for any help

InStep

p.s. I should say that I'm using Excel.

Select the cells you want to change, then DATA VALIDATION.

Change from Custom to Any Value

No password required

--kiloran

kiloran wrote:Select the cells you want to change, then DATA VALIDATION.

Change from Custom to Any Value

No password required

Thanks I'll give it a try tomorrow.