Time is an important resource that every company treasures and attempts to change into a gain. In choosing document management software program, pay attention to a clutterless and user-friendly interface that empowers users. DocHub delivers cutting-edge features to optimize your file administration and transforms your PDF file editing into a matter of one click. Hide Dropdown to the Collateral Debenture with DocHub to save a lot of time as well as boost your productiveness.
Make PDF file editing an simple and easy intuitive process that helps save you plenty of precious time. Effortlessly modify your files and deliver them for signing without turning to third-party alternatives. Focus on relevant tasks and improve your file administration 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