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.
Removing Validation from HYPTUSS
-
- 2 Lemon pips
- Posts: 155
- Joined: November 4th, 2016, 4:52 pm
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Removing Validation from HYPTUSS
Select the cells you want to change, then DATA VALIDATION.
Change from Custom to Any Value
No password required
--kiloran
Change from Custom to Any Value
No password required
--kiloran
-
- 2 Lemon pips
- Posts: 155
- Joined: November 4th, 2016, 4:52 pm
Re: Removing Validation from HYPTUSS
Thanks I'll give it a try tomorrow.kiloran wrote:Select the cells you want to change, then DATA VALIDATION.
Change from Custom to Any Value
No password required