You didn't have to remove it (lcase) if you didn't change the no to No. You
need to do one or the other - not both.

Apparently you have a bad teacher <g

--
Regards,
Tom Ogilvy


"Pasty" wrote:

Its okay I figured it out I just had to remove the LCase bit. Thanks for all
your help guys.

" wrote:

Hi
This code needs to be in the correct place or it won't work. Open the
VB editor. In the project window (left hand side) you will see your
excel filename and under it various sheet names. Double click the
sheetname where you have your dropdown (I was assuming this was a
validation list to give you consistency of spelling yes/no). Now paste
Tom's code into the blank module.
I'm assuming, of course, that your dropdown really is in column P??
Also, I'm assuming you changed the value to no from yes. This will
fire the change event.
The events enabled bit just allows your sheet to respond to the change
in the cell value. You can switch this off using code but you probably
havn't done this so nothing to worry about there.
regards
Paul