Consulting

Results 1 to 3 of 3

Thread: Disable msg SaveAs

  1. #1

    Disable msg SaveAs

    Hi, Is possible to disable msg save/replace file confirmation dialogBox by code module? tks.

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Are you saving by code or manually

    Does it happen when you try to save to a filename that already exists?

    What steps are you taking and when does the alert occur and what does it say?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    I'm sorry , for code I use this :

    Option Explicit

    Sub DisableSaveAs()
    Dim strName As String
    strName = ActiveWorkbook.Name
    strName = InputBox("Please,....:", , strName)
    If strName = "" Then Exit Sub
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs strName
    Application.DisplayAlerts = True
    End Sub

    For real I should like of disabling the message of the manual, but by VBA, is possible?

Posting Permissions

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