PDA

View Full Version : xlDialogSaveAs: Lock it to a specific directory?



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