LinkBack URL
About LinkBacks
Hi
Can you tell me a VBA Code where I can Hide and Show using a button different columns within a sheet. So as the user presses Hide the columns will be hidden and vice versa for the show.
Regards
Hi
Can you tell me a VBA Code where I can Hide and Show using a button different columns within a sheet. So as the user presses Hide the columns will be hidden and vice versa for the show.
Regards
Hi Aisha890:
Have a look at these:
Regards,
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Please Login or Register to view this content.
and for show
Please Login or Register to view this content.
However it shows the code as in break mode
I need a code where in columns K and M wherever there is date. Upon clicking the hide button it will hide and show for the vice versa.
Also when I try to connect it with the button by altering the code from the view code option. It takes me to the code instead of performing the actions. Please tell me how to resolve it.
Last edited by Aisha890; 04-19-2016 at 04:31 AM.
This code will hide your desired columns if they're not hidden or show them if they're hidden:
If the code is going into break mode I'm guessing there's a syntax error with it. I've tested mine and there's no issue.Please Login or Register to view this content.
Regards,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks