Sure this may be an easy one and i'm overthinking it.........

I have approx 10 worksheets in my bookbook, each as a 1 command button
per month (therefore 12 buttons per sheet) The user selects which month
they will be updating from a combobox when the workbook starts, all
month-buttons except those for the month the user has selected are then
disabled. E.g. if you pick January then you can only click the January
update button and every other month button is disabled in ALL the
sheets.

Obviously i don't want to set up a Workbooks.Worksheets.button.Enabled
= False line for hundreds of combinations in my SELECT CASE
function.........so is there a way i can disable all command buttons
EXCEPT those who meet the CASE criteria in the select case function?

Thanks

Emm100


--
Emm100


------------------------------------------------------------------------
Emm100's Profile: http://www.excelforum.com/member.php...o&userid=23236
View this thread: http://www.excelforum.com/showthread...hreadid=374114