Creating VBA Button to Do Two Operations Simultaneously

Hi /all,

I would like a VBA code that completes two operations at the same time. I am an extreme novice and pretty much need to the whole thing spelled out for me.

I would like a button on Sheet1 to do the following two commands simultaneously:
- Hide Sheet2
- Hide ColumnB in Sheet3

I will also have another button that does the opposite of the above (I am pretty such I can figure that out once I have the above code).

Thank you in advance!

DJC

See attached.

Hi Paul,

Thanks for the help! I'm really sorry but I've just realised it's a little more complicated than this, still wondering if you can help!

So, I want "Private Sub CommandButton2_Click()" to do THREE things (sorry, not two):
1 - Close Sheet2
2 - Close columns C, K, S, AA on Sheet3
3 - Hide columns C, J, R Z on Sheet4

Sheet 2 Name - Thai Menu
Sheet 3 Name - Menu-MASTER
Sheet 4 Name - Options-MASTER

I have used a command button for this process, please advise me if you think their is a better solution (perhaps an ON/OFF button that shows/hides the above).

Thanks again,

Danny


(Thai Menu)

Using the same button

Please Login or Register  to view this content.