Hide Personal Macro in VBA Project Explorer

[DavidGold]

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 ?

Thanks.

[Rob Bovey]

"DavidGold" <[email protected]> wrote in
message news:[email protected]...
> 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

[Nigel]

You can hide it - but the user can still unhide, the macros will also be
visible. I use the following method in the workbook open event, to close
the Personal.xls if there is one.

' if user has a personal.wks in xlstart directory - close it!
Dim wb As Workbook
For Each wb In Application.Workbooks
If UCase(wb.Name) = "PERSONAL.XLS" Then
Application.DisplayAlerts = False
wb.Close
Application.DisplayAlerts = True
End If
Next


--
Cheers
Nigel



"DavidGold" <[email protected]> wrote in
message news:[email protected]...
>
> 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 ?
>
> Thanks.
>
>
> --
> DavidGold
> ------------------------------------------------------------------------
> DavidGold's Profile:
http://www.excelforum.com/member.php...o&userid=26703
> View this thread: http://www.excelforum.com/showthread...hreadid=399690
>

[Dave Peterson]

You can't hide it, but you could protect it so that it can't be viewed*.

With that project selected (in the VBE):
tools|VBAProject Properties|Protection tab
give it a nice memorable password (and lock it for viewing)

*Be aware that this kind of protection can be broken pretty quickly--but it will
keep the casual user out of your code.



DavidGold wrote:
>
> 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 ?
>
> Thanks.
>
> --
> DavidGold
> ------------------------------------------------------------------------
> DavidGold's Profile: http://www.excelforum.com/member.php...o&userid=26703
> View this thread: http://www.excelforum.com/showthread...hreadid=399690

--

Dave Peterson