What is difference between sheet Hidden and Very Hidden?

Thanks

The biggest difference is whether the user can see (and show) the worksheet via
the:

Format|sheet|Unhide dialog



Marc wrote:

What is difference between sheet Hidden and Very Hidden?

Thanks

--

Dave Peterson

And that you can make a sheet very hidden only via VBA

"Dave Peterson" wrote:

The biggest difference is whether the user can see (and show) the worksheet via
the:

Format|sheet|Unhide dialog



Marc wrote:

What is difference between sheet Hidden and Very Hidden?

Thanks

--

Dave Peterson

Or manually via the VBE (in the properties for that worksheet).

Duke Carey wrote:

And that you can make a sheet very hidden only via VBA

"Dave Peterson" wrote:

The biggest difference is whether the user can see (and show) the worksheet via
the:

Format|sheet|Unhide dialog



Marc wrote:

What is difference between sheet Hidden and Very Hidden?

Thanks

--

Dave Peterson


--

Dave Peterson

hmmm, yeah. I kinda sorta forgot about that.

"Dave Peterson" wrote:

Or manually via the VBE (in the properties for that worksheet).

Duke Carey wrote:

And that you can make a sheet very hidden only via VBA

"Dave Peterson" wrote:

The biggest difference is whether the user can see (and show) the worksheet via
the:

Format|sheet|Unhide dialog



Marc wrote:

What is difference between sheet Hidden and Very Hidden?

Thanks

--

Dave Peterson


--

Dave Peterson

The biggest difference is whether the user can see (and show) the
worksheet via
the:
Format|sheet|Unhide dialog

If I have Very Hidden sheets, and protect sheet, workbook and VBA project
with password, and someone unprotect sheet, he has to unprotect also VBA
project so that he can see sheets?

Thanks

Many users have their own personal macros that can make worksheets visible.

If you want to make it a little more difficult, then when you protect the
workbook:

Tools|Protection|protect workbook
make sure you check that Structure checkbox.

But there is code that is freely available that can remove the worksheet
protection and workbook protection in a matter of moments.

The VBA project protection won't even come into play for this.

And protecting a worksheet doesn't affect the visibility of that worksheet.



Marc wrote:

The biggest difference is whether the user can see (and show) the
worksheet via
the:
Format|sheet|Unhide dialog

If I have Very Hidden sheets, and protect sheet, workbook and VBA project
with password, and someone unprotect sheet, he has to unprotect also VBA
project so that he can see sheets?

Thanks

--

Dave Peterson