Time is an important resource that each company treasures and tries to turn in a benefit. When choosing document management software, be aware of a clutterless and user-friendly interface that empowers users. DocHub offers cutting-edge features to optimize your document managing and transforms your PDF file editing into a matter of one click. Hide Dropdown List to the End-Of-Life Plan with DocHub to save a ton of time as well as increase your efficiency.
Make PDF file editing an simple and intuitive operation that saves you plenty of precious time. Quickly modify your documents and send them for signing without having switching to third-party software. Focus on relevant duties and improve your document managing with DocHub today.
hey and thanks for watching today Im going to show you how to use drop down menus to hide and unhide tabs now I do real estate financial modeling and so my example here is I have a user who may want to model real estate development or may want to model a real estate acquisition and so I want the ability for them to choose that and have the relevant tabs hide be hidden or unhidden based on that selection and then me as a creator of this model I want the ability to quickly hide and unhide hide my calculation tabs without coming down doing the right click and hide one by one to hide them hide those calculation tabs so lets get started this takes some basic VBA you dont need to know how to code Ive included the code on the on the post attached to this video as well as in the video itself and its just a matter of copy paste and fill in a few inputs but before we get to the VBA what I like to do is I like to name the cells where we have these drop-down menus now why do I like to do that