Hi all,

is there a way to hide your sheets from appearing in the object browser?

I've got a protected VBA/Excel project and all the sheets appear in the
object browser, yet for other .xla add-ins, no sheets appear when you switch
the object browser to them.

Tx.

Mike.

"Mike" wrote in message
...
is there a way to hide your sheets from appearing in the object browser?

I've got a protected VBA/Excel project and all the sheets appear in the
object browser, yet for other .xla add-ins, no sheets appear when you
switch
the object browser to them.

Hi Mike,

If you have worksheets in your add-in they're going to show up in the
object browser no matter what. When you see an add-in that doesn't show any
worksheets in the object browser (the analysis toolpak add-in funcres.xla is
one example) it's because the only sheets it contains are XLM macro sheets
or Excel 5/95 dialog sheets. These two sheet types don't appear in the VBE
or in the object browser but they will satisfy Excel's requirement that
every workbook contain at least one sheet of some kind.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

Rob,

thanks for the info, that's exactly why I was asking.
"Rob Bovey" wrote in message
...
"Mike" wrote in message
...
is there a way to hide your sheets from appearing in the object browser?

I've got a protected VBA/Excel project and all the sheets appear in the
object browser, yet for other .xla add-ins, no sheets appear when you
switch
the object browser to them.

Hi Mike,

If you have worksheets in your add-in they're going to show up in the
object browser no matter what. When you see an add-in that doesn't show
any
worksheets in the object browser (the analysis toolpak add-in funcres.xla
is
one example) it's because the only sheets it contains are XLM macro sheets
or Excel 5/95 dialog sheets. These two sheet types don't appear in the VBE
or in the object browser but they will satisfy Excel's requirement that
every workbook contain at least one sheet of some kind.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm