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