Designate a folder as the root of the Browse tree
 

hi All,
What I am trying to achieve is to have a folder to appear as the root
directory whereby the user can't see any of the parent folders of the
folder that has been designated as the root directory. I am using Jim
Rechs BrowseForFolder macro, which brings up a dialog box of which I
can select a folder but having the root as the desktop.

For example instead of showing in the dialog box

-c
-admin
+2002
-2003
+1Jan
+2Jan
I want it to show only
-2003
+1Jan
+2Jan

thereby hiding anything before 2003 in the browse dialog.

Thanks in advance,
Kiwichico
:confused:



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/