Excel VBA - Hiding/Displaying worksheets

by HapaKazi

This is a macro file I use to manage workbooks that have a large number of worksheets. When I used to work on company budgets for my previous employers I used to do it in one excel workbook with more than 50 sheets. This workbook had worksheets for for each department and summary sheets for the projected Balance sheet, Profit and loss statement and cash flow projection. Navigating through 50 worksheets in the same file was quite tedious and therefore I developed this tool to help me hide all the sheets and leave the few ones I was working on. The vba code proved to be useful as I could also hide sensitive data like salaries while making budget presentations before departmental managers.

image of username HapaKazi Flag of Kenya Nairobi , Kenya

About Me

Hello. I am good at customizing excel to solve your business problems. I can do excel VBA macros and VBA solutions to make your office tasks easier . I do prepare financial models and projections that making business decision making easy. Please check out samples of my work from the portfolio section of this profile. Kind Regards, Martin.

$ 15 USD/hr

NEW FREELANCER!

Tags