Thread: Hide Personal Macro in VBA Project Explorer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
  
Posts: 811
Default Hide Personal Macro in VBA Project Explorer
"DavidGold" wrote in
message ...
Although I hide the perosnal macro workbook in Excel, it still appear in
the VBA project explorer.
How to hide it in the VBA project explorer as well :) ?

Hi David,

There's no way to hide a standard Excel workbook like Personal.xls
(which is just a hidden workbook, choose Window/Unhide from the Excel menu
and you'll see it) or add-in from the Visual Basic Editor Project Window.

--
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


Reply With QuoteReply With Quote