View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Court Court is offline
external usenet poster
 
Posts: 4
Default Saved a workbook using xlDialogSaveAs, now it has a password ?!?

=DoH!=
Of course it's all caps. Thanks for taking the time to look in to my
problem-
I really appreciate it.
Thanks Guys!


"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