Using Office 2003 and Windows XP;

You can "very hide" a sheet.

You can "hide" a workbook.

But, can you "very hide" an Excel workbook using VBA? Or, can you "very
hide" an instance of the application? If so, what would the VBA look like?

Thanks much in advance.

Yes. Very Hidden hides the worksheet and prohibits the user from unhiding it
through the Format -> Sheets -> Unhide menu.

Here's the code:

Sub veryHidden()
Worksheets("mySheet").Visible = xlVeryHidden
End Sub

HTH,
Pflugs

"XP" wrote:

> Using Office 2003 and Windows XP;
>
> You can "very hide" a sheet.
>
> You can "hide" a workbook.
>
> But, can you "very hide" an Excel workbook using VBA? Or, can you "very
> hide" an instance of the application? If so, what would the VBA look like?
>
> Thanks much in advance.

There's nothing directly equivalent however, temporarily or even permanently
changing the workbook's IsAddin status achieves same. Ie no visible sheets
and not shown under Window > Unhide. The workbook's project remains visible
in the VBE, as does an xlSheetVveryHidden sheet.

Dim wb As Workbook
Set wb = Workbooks("VeryHiddenBook.xls")
wb.IsAddin = True

Concerning your second question, with automation you can choose whether to
make the Excel instance Visible.

Regards,
Peter T


"XP" <(E-Mail Removed)> wrote in message
news:05B23575-7E50-456E-9C1E-(E-Mail Removed)...
> Using Office 2003 and Windows XP;
>
> You can "very hide" a sheet.
>
> You can "hide" a workbook.
>
> But, can you "very hide" an Excel workbook using VBA? Or, can you "very
> hide" an instance of the application? If so, what would the VBA look like?
>
> Thanks much in advance.

I'm asking about the WORKBOOK or the APPLICATION; not a sheet...

"Pflugs" wrote:

> Yes. Very Hidden hides the worksheet and prohibits the user from unhiding it
> through the Format -> Sheets -> Unhide menu.
>
> Here's the code:
>
> Sub veryHidden()
> Worksheets("mySheet").Visible = xlVeryHidden
> End Sub
>
> HTH,
> Pflugs
>
> "XP" wrote:
>
> > Using Office 2003 and Windows XP;
> >
> > You can "very hide" a sheet.
> >
> > You can "hide" a workbook.
> >
> > But, can you "very hide" an Excel workbook using VBA? Or, can you "very
> > hide" an instance of the application? If so, what would the VBA look like?
> >
> > Thanks much in advance.

My mistake.

"XP" wrote:

>
> I'm asking about the WORKBOOK or the APPLICATION; not a sheet...
>
> "Pflugs" wrote:
>
> > Yes. Very Hidden hides the worksheet and prohibits the user from unhiding it
> > through the Format -> Sheets -> Unhide menu.
> >
> > Here's the code:
> >
> > Sub veryHidden()
> > Worksheets("mySheet").Visible = xlVeryHidden
> > End Sub
> >
> > HTH,
> > Pflugs
> >
> > "XP" wrote:
> >
> > > Using Office 2003 and Windows XP;
> > >
> > > You can "very hide" a sheet.
> > >
> > > You can "hide" a workbook.
> > >
> > > But, can you "very hide" an Excel workbook using VBA? Or, can you "very
> > > hide" an instance of the application? If so, what would the VBA look like?
> > >
> > > Thanks much in advance.

No problem, thanks for the effort...

"Pflugs" wrote:

> My mistake.
>
> "XP" wrote:
>
> >
> > I'm asking about the WORKBOOK or the APPLICATION; not a sheet...
> >
> > "Pflugs" wrote:
> >
> > > Yes. Very Hidden hides the worksheet and prohibits the user from unhiding it
> > > through the Format -> Sheets -> Unhide menu.
> > >
> > > Here's the code:
> > >
> > > Sub veryHidden()
> > > Worksheets("mySheet").Visible = xlVeryHidden
> > > End Sub
> > >
> > > HTH,
> > > Pflugs
> > >
> > > "XP" wrote:
> > >
> > > > Using Office 2003 and Windows XP;
> > > >
> > > > You can "very hide" a sheet.
> > > >
> > > > You can "hide" a workbook.
> > > >
> > > > But, can you "very hide" an Excel workbook using VBA? Or, can you "very
> > > > hide" an instance of the application? If so, what would the VBA look like?
> > > >
> > > > Thanks much in advance.