Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Personal Macro in VBA Project Explorer
Although I hide the perosnal macro workbook in Excel, it still appear i the VBA project explorer. How to hide it in the VBA project explorer as well :) ? Thanks -- DavidGol ----------------------------------------------------------------------- DavidGold's Profile: http://www.excelforum.com/member.php...fo&userid=2670 View this thread: http://www.excelforum.com/showthread.php?threadid=39969 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Personal Macro in VBA Project Explorer
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" 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 :) ? Thanks. -- DavidGold ------------------------------------------------------------------------ DavidGold's Profile: http://www.excelforum.com/member.php...o&userid=26703 View this thread: http://www.excelforum.com/showthread...hreadid=399690 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Personal Macro in VBA Project Explorer
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Project Explorer list | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
VBA Project Explorer | Excel Programming | |||
Bizarre Project Explorer in VBE | Excel Programming |