Urgent - Need help with Excel, please help!

[CarGirl]

This is for pre-school

I have an invoice spreadsheet and on it are drop down arrows that take you to a list where you select the correct payment rate, or in another they correct age etc.

How do I amend what is in the drop down list - I can't find another sheet where it is or anything like that???? Don't even know what it is called to look it up in excel help.

I think I may have some more questions later too changing an "If" formula.

Thank you

[CarGirl]

I don't have the pre-school laptop on at the moment the administrator has it, will hopefully get it back in a few days.

[Flier]

can you try copying it again?

[CarGirl]

okay have just discovered the blank disc I tried to copy it onto wasn't blank it is dh's ipod stuff - grrrrrrrrrrrrr so not wonder it didn't work!

[CarGirl]

Plan has been foiled, copied spreadsheets onto disc from pre-school's laptop and my laptop can't find them I only have excel 2003 so perhaps it can't recognise them?

Perhaps I will have to go back to the beginning and just write my own spreadsheet with drop down boxes

Thanks for all your help, I don't even have the pre-school laptop anymore to try the ideas given yesterday pm.

[Flier]

cargirl, i'll have a go at your spreadsheet if you're happy for me to look too, i don't like putting email on here, but you can cat me and i'll cat you back.

[MonsieurHHTruqueur]

Did you email it to me? Haven't had it

[CarGirl]

Have been at the wine, will be back on this thread on Wednesday to try it all again......if anyone else wants a copy of the spreadsheet to have a go let me have your email addy!!!

At least I managed to crack the cash book problems on my own!

[DadInsteadofMum]

When on the cell go to Data / Validation it should then should have a pop up box showing which validation options are in force. Allow list should be selected, there will then either be a list of words, a range of cells, or a single word range name.

If a list of words then edit in the pop up box, is a cell range then go to the cells referenced edit the list, if you extrend the list then you will have to go back to the pop up box and edit the range.

If a single word range name then come back and we can go through that.

[Kevlarhead]

I have a password cracker that will do sheet-level passwords if you need it?

[SharpMolarBear]

Drop down list options are usually in Data menu under validation

[Flier]

[SAD] think dh has thrown them in the bin

[Flier]

just thought - i have some excel tutorials upstairs, will take a look and see if there is anything relevant for you.

[CarGirl]

will do Flier

Anyone fancy designer better invoices anyway. You can so tell it was a bloke who did them!

[Flier]

when trying to view the code, have you tried entering any passwords? if you try password, that is soemtimes the default.

[CarGirl]

I will send it to you tonight. It doesn't even have the internet so I will have to copy it onto disc to send it from my PC. Thanks for offer!

[Flier]

oh, wish i could help, thsi sort of thing used to be right up my street, but I managed to delete my excel program last week and I have no discs to reinstall

hope you manage to get it ok, they've got to be somewhere!

[CarGirl]

no hidden columns

grrrr at accountant, guess that will this weeks job rewriting it!

[VinegARGHHHTits]

Unless you know the password then i am afriad you are not going to be able to change it, sorry couldnt be more help.

[CarGirl]

There aren't any sheets to unhide.

When viewing the code it doesn't tell me anything helpful apart from it is password protected

Guess I will have to rewrite the whole thing at some point or find an excell whizz to help in person!

[VinegARGHHHTits]

Cargirl if you right click on the sheet tab and 'view code' you might be able to amend what is in the list from there if it is hard coded in, you will also be able to see all the hidden sheets within the workbook and the code behind them. hth

[CarGirl]

I just need to find "the list" and add to it I think?