Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password on Save As Screen (Excel 2000)

    Is there a way to put a button on the Save As Screen instead of going to Tools General Options to input a password?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password on Save As Screen (Excel 2000)

    Others will correct me if I'm wrong, but I don't think that you can customize the built-in Save As dialog.

    You could create your own dialog as a userform, and replace the Save As... command in the File menu by a custom menu item that opens the userform, but that would probably be more work than it's worth

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password on Save As Screen (Excel 2000)

    If you are trying to automate this process you can do it similar to the following (excerpted from one of my books, just to illustrate the context):

    --------------------------------------------
    If ardvark = vbCancel Then End
    Application.DisplayAlerts = False
    ThisWorkbook.SaveAs Filename:= _
    "C:TiddlyWinksIncomingSalesSales.xls", FileFormat:=xlNormal, _
    password:=""
    ThisWorkbook.SaveAs Filename:= _
    "C:TiddlyWinksPrevious Months" & catch & ".xls", FileFormat:= _
    xlNormal, password:="", writerespassword:="boneleg"
    Unload Loc
    -----------------------------------------

    If you wished, I guess you could prompt for a password before saving, but as Hans says, might be more trouble than it is worth. If you use the same password lots of places, it might be worthwhile to use a Public Constant so if you wished to later change it, you would only have to change it one place.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •