Help with hiding rows using If functions in VBA

[excelnoob123456]

Hi everyone

I'm currently trying to edit an excel spreadsheet for work having (stupidly) said that I could improve on it. Now, it has been created by someone else who no longer works there and I'm not sure about everything on there and I'm learning as I go because my Excel knowledge is fairly average. I don't want to post the whole sheet on here because it belongs to my employer but I wondered if someone could help with these if functions which I'm using to try and hide and unhide various rows using drop down boxes as they are driving me crazy. The following is the part that I am working on at the minute:

Please Login or Register  to view this content.

The idea is to get rows 15-17 displayed if K14 is Yes, and to get rows 15-20 displayed if G14 is no, but to have all 15-20 hidden if k14 is no and g14 yes or if no option has yet been selected.

Any help greatly appreciated as it's driving me crazy.

We would love to help you with your query, but first, before we can proceed, please see Forum Rule #8 about cross posting...

sorry, also posted here:
http://www.mrexcel.com/forum/excel-q...lications.html

[protonLeah]

Please Login or Register  to view this content.

[excelnoob123456]

Please Login or Register  to view this content.

Thanks very much missed that bit

I've now actually finished the spreadsheet after a few long hours, the only thing I'm now trying to do is protect the sheet so users don't accidentally edit fields, I have selected only the fields they should be able to edit and locked and password protected the rest, the only problem I have is any time a locked cell is clicked on a password prompt pops up which is very annoying for the user. Is there any way to disable this?

Thanks for all your help

[protonLeah]

Sorry, I don't think I can help with that one. Did you deselect the option "select locked" cells when you protected the sheet?