-
xlDialogSaveAs: Lock it to a specific directory?
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:
[vba] Application.Dialogs(xlDialogSaveAs).Show (strPath) [/vba]
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules