Stop showing the Folder explorer bar?

  • Thread starter Thread starter M. Authement
  • Start date Start date
M

M. Authement

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.
 
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 View>Explorer 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top