Excel should prompt you to enter the password you set earlier. Only users with the correct password will be able to access the VBA project and modify the visibility settings of the worksheets.

This will also hide the selected worksheet. Hiding Sheets with VBA (Advanced Option) For an extra level of hiding (where the sheet doesn’t appear even in the Unhide menu), press Alt + F11 to open the ...

In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.