Home » Forums » Open Source Learning Center » Question and Answer

Hiding a sheet forever from end users

Submitted by louglas on 7 November, 2012 - 01:51

Hi All,

I have come up with an excel file [Excel 2007] where the sheets are designed to process some business related information.

Im looking for ways to hide the sheet forever from end users.

The options like Visible property can be broken using VBA code.
Is there a way, i can hide the sheet and its contents from end users.
Thanks in advance

‹ Copy all the sheets from Source excel to Destination Excel with same sheet names and data copy data from one cell to another ›
»
Nick's picture

In vba editor, change the

Submitted by Nick on 7 November, 2012 - 07:22.

In vba editor, change the property of the sheet from visible to xlveryhidden

»