Hiding/Unhiding cells using vba

[rmahal1]

Hi All,

Can anyone advise, I have not really done a lot of programming in excel. I have an excel sheet which is used a take off list for a mchine which as a number of variations.
My first problem which i managed to solve was turning off a particular set cells if the machine size was any size other than 1750.
My next problem is I want to create another one which will turn off cells if the value in a another cell says yes or no. Can anyone Advise.

Vba Script so far:

Please Login or Register  to view this content.

[royUK]

Welcome to the Forum, please take the time necessary to read the Forum Rules & in future follow them. I will add Code Tags for you this time.

You can only have one WorkSheet_Change event per worksheet, you need to combine thisa code.

[royUK]

Try something like this

Please Login or Register  to view this content.

I would have thought you would need to unhide any previously hidden rows as well.

[rmahal1]

Thanks for your reply. Have tried the code but does not do anything within my excel sheet.
As for unhiding other cells. I want to use the takeoff sheet that will allow me to produce a takeoff list for variations of the machine. Once I get this section of the code to work i will also hope to add additoinal repeative lines of code for more varations based on a yes or no input. Thanks again.

[royUK]

I can't test this because i haven't got your workbook, you can attach it here.

Are you sure that you have placed the code in the correct place?

[rmahal1]

Hi Managed to get the first part of code to work still having troubled with the yes & no part of hte code to do anything. I have attached Workbook. Again Thanks for your help.

[royUK]

Is this working how you want?

Please Login or Register  to view this content.

[rmahal1]

Thankyou, it works fine now.

[royUK]

Thanks for the feedback.