How do I hide multiple command buttons on one sheet

**chillman** · 03-23-2013, 12:24 PM

I am new to VB in Excel and I need to have several command buttons hidden based on cell values

I can get this to work with either one if pasted separately but I cannot seem to stack the codes under the worksheet - I would like to be able to hide up to 8 or 9 command buttons based on cell values if possible

Please Login or Register  to view this content.

Any ideas
Thanks
Chris

**JBeaucaire** · 03-23-2013, 12:34 PM

I'm thinking this does the same thing:

Please Login or Register  to view this content.

**JBeaucaire** · 03-24-2013, 08:45 PM

Any other questions, Chris? If that worked for you, select Thread Tools from the menu above and set this thread to [SOLVED]. Thanks.

**chillman** · 03-25-2013, 10:17 AM

It does work but I do get a runtime error 13 since on of my cell values has a #value when I reset my sheet (I can fix this) It does slow down the reset Macro from about .5 seconds to over 5 seconds.
Thanks
Chris