How to make Excel worksheet very hidden

Published: 30 August 2023
on channel: Excel and VBA Hindi Tutorial
132
7

In Excel, there are two levels of visibility for worksheets: "hidden" and "very hidden." A "very hidden" worksheet is not visible in the Excel interface, and it cannot be unhidden using the typical methods. You can use VBA (Visual Basic for Applications) code to make a worksheet very hidden. Here's how you can do it:

Open your Excel workbook.

Press ALT + F11 to open the Visual Basic for Applications (VBA) editor.

In the Project Explorer window on the left, find and select the worksheet you want to make very hidden. It will be listed under the name of the workbook.

Go to the Properties window (if it's not already visible, press F4 to show it).

Locate the "Visible" property in the Properties window and change its value from "xlSheetVisible" to "xlSheetVeryHidden".


Watch video How to make Excel worksheet very hidden online without registration, duration hours minute second in high quality. This video was added by user Excel and VBA Hindi Tutorial 30 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 132 once and liked it 7 people.