Saved a workbook using xlDialogSaveAs, now it has a password ?!?
Hi,
You can find the argument list any dialog by searching the online help for
"Built-In Dialog Box Argument List".
For the SaveAs, it is:
xlDialogSaveAs -- document_text, type_num, prot_pwd, backup,
write_res_pwd, read_only_rec
therefore, it correspond to the False.
It must have transform the False as a string and used it for password.
False.. no luck
false... no luck
FALSE... here we go ... it is the one !!!
try leaving the param blank like:
Application.Dialogs(xlDialogSaveAs).Show "Rename ME", True, , False
Would that work?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
"Court" wrote:
i wrote a macro that prompts the user to save the workbook. Now the saved
workbook has a password. I did not set one.
Here's my code. Does anyone have an idea what the password might be?
Thanks!
Sub PromptSaveAS()
Application.Dialogs(xlDialogSaveAs).Show "Rename ME", True, False, False
'document_text , type_num, prot_pwd, backup, write_res_pwd, read_only_rec
End Sub
|