sjrx0213
11-28-2007, 02:55 PM
First off, this is a great site. I'm glad I stumbled across it!
Here's my scenario: I've got a wizard to set up a workbook and xlDialogSaveAs gives me the best (i.e. easiest) handling of duplicate file names, cancellations, etc. I've got the default directory set:
Application.Dialogs(xlDialogSaveAs).Show (strPath)
but I'd like to know if there's a way to "lock" it so a user can't navigate out of the workbook's home dir.
I don't see anything obvious in the documentation in VBA Help.
Thanks,
--Steve
Here's my scenario: I've got a wizard to set up a workbook and xlDialogSaveAs gives me the best (i.e. easiest) handling of duplicate file names, cancellations, etc. I've got the default directory set:
Application.Dialogs(xlDialogSaveAs).Show (strPath)
but I'd like to know if there's a way to "lock" it so a user can't navigate out of the workbook's home dir.
I don't see anything obvious in the documentation in VBA Help.
Thanks,
--Steve