Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop showing the Folder explorer bar?
I have added a custom menu as part of an add-in which contains a button that
brings up a folder. This works, but the Folder explorer bar is shown and I would prefer that it didn't. Any thoughts on how to eliminate the Folder view? The code I have attached to the button is shown below. ActiveWorkbook.FollowHyperlink Address:="\\someservername\folder1\folder2", NewWindow:=True Oh, and I am using Excel 2003/WinXP. TIA for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop showing the Folder explorer bar?
Application.CommandBars("Web").Visible = False
NickHK "M. Authement" .gbl... I have added a custom menu as part of an add-in which contains a button that brings up a folder. This works, but the Folder explorer bar is shown and I would prefer that it didn't. Any thoughts on how to eliminate the Folder view? The code I have attached to the button is shown below. ActiveWorkbook.FollowHyperlink Address:="\\someservername\folder1\folder2", NewWindow:=True Oh, and I am using Excel 2003/WinXP. TIA for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop showing the Folder explorer bar?
Nick,
I assume that bit of code would hide Excel's Web toolbar, but it does do what I am looking for (at least I could not get it to work). What I am attempting to do is open a folder in a separate Windows Explorer window that contains a bunch of files (Word documents to be exact). Using the ActiveWorkbook.FollowHyperlink does achieve this goal, but on the left side of the window is a treeview list of folders. If I select ViewExplorer Bars I can see that the Folders bar is checked (and can then uncheck it so that it no longer appears). Can I does this programmatically using VBA code, and more specifically, how? "NickHK" wrote in message ... Application.CommandBars("Web").Visible = False NickHK "M. Authement" .gbl... I have added a custom menu as part of an add-in which contains a button that brings up a folder. This works, but the Folder explorer bar is shown and I would prefer that it didn't. Any thoughts on how to eliminate the Folder view? The code I have attached to the button is shown below. ActiveWorkbook.FollowHyperlink Address:="\\someservername\folder1\folder2", NewWindow:=True Oh, and I am using Excel 2003/WinXP. TIA for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy explorer folder list to excel | New Users to Excel | |||
how do i remove folder explorer side bar | Excel Worksheet Functions | |||
Embed Folder Treeview Or Windows Explorer On UserForm | Excel Programming | |||
Multiple instances of a workbook showing in Project Explorer | Excel Programming | |||
Displaying Folder Structure and Files from WIndows Explorer to Excel | Excel Programming |