Dear sir/madam,
I hope you could help me with the following problem. I have attached an worksheet. In column A I have a drop-down box. Next to the drop-down box there is table 1. Is it possible to hide table1 if I choose 2 and 3? If I choose 1 it will be visble again.
Thanks in advance.
Kind regards,
Ka-Wai
test1.xlsx
From your workbook, press Alt+F11 to open the VBA window. Select View - Project Explorer, and in that pane, double-click Sheet1 to open the Sheet1 code module. Paste the following into it. When you save the workbook, you'll need to save it as a .xlsm (macro-enabled).
Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks