And have hide all other worksheets, it may be confidential or not useful to that department. While sending the workbook to a specific department, you need to show the worksheets related to that particular department. Like HR, Admin, Finance, etc…, all of these may have same knind of data but the data (numbers) may vary from one department to another. For Example you may be developing a tracker for different departments in an organization. You can hide unhide worksheets using Excel VBA. VBA hide unhide worksheets example macro macro helps when we have many worksheets in a workbook and you want to show only specific worksheets to the user.
