Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dialogs (close thru VBA) (VBA/MS Excel/97)

    As part of a project I am developing, a user prints a label.

    I have a new sheet inserted into the workbook and then the relevant address details pasted before the sheet is deleted. (The user does not see any of this.)

    My problem is that the confirmation dialog appears when the sheet is about to be deleted, and I wonder is there a way for it not to appear. Can SendKeys statement provide a solution (but a quick search of the Forum would tend to make one steer clear of that command)?

    If so how can it be used?

    Leigh

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialogs (close thru VBA) (VBA/MS Excel/97)

    Solved with the following:

    <pre> Application.DisplayAlerts = False</pre>

    Leigh

Posting Permissions

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