Can anyone help?
I have a spreadsheet that has a data validation dropdown box in the top left corner.
I want to know if there is a way, that when something is selected in that dropdown, for arguments sake, lets say we select 'Item 1'from the dropdown. I need for the sheet to then hide certain columns when that item is selected, can this be done?
Possible through VBA but I'm not too familiar with using VBA to hide columns so I'cant give you an example code unfortunately.
Please Login or Register to view this content.
TechRetard.ToString();
There are always multiple ways to do something, when it doubt, drink a beer.
I do not care if you rep or not but please mark post as Solved if there is resolution so I stop going back and checking if anything else is needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks