I came across an old thread by martindwilson (full credit to him) ‘How to hide command button based on another cell?’ (http://www.excelforum.com/excel-prog...ml#post3561021).
This works faultlessly but for only 1 Button. I tried adding in the code again for a second Button but it creates a conflict. I made a slight adjustment to your original code, to show the button when the cell is populated, which works well…
Does anyone know a way I can:-
1. Add additional buttons which reference their own cell?
CommandButton4 – H9
CommandButton6 – I9
CommandButton2 – Q9
CommandButton3 – S9
2. And add one button which activates based on one of 3 cells?
CommandButton1 – J9 &/or V9
Any assistance would be greatly appreciated as I am a VBA novice.
http://www.ozgrid.com/forum/showthread.php?t=185711
Bookmarks