(Solved) – VBA to Hide/Unhide range of columns and worksheets based on response to inputbox [closed]


I’m working on a project where I want to build a macro to setup an excel workbook, but I’m brand new to VBA and have no idea how to write this code.

What I want to do is use a file that I have created which has an overview worksheet, followed by up to 20 daily specific worksheets. On the overview sheet I want to create a “setup” button that will bring up an inputbox asking for the number of days, and based on the response I want the command to hide (or unhide) the correct number of worksheets as well as hide/unhide the correct number of columns on the overview page.

I am working with Excel 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *