Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Question Unanswered: Disallowing windows messages in excel

    Hi all,
    I have a small macro in one workbook that open another workbook in memory :

    dim xls as workbook
    set xls = application.excel
    xls.open "c:\..."

    everything works fine, but on the opened workbook in memory I am deleting some sheets and saving at the end and I would like to get rid of the windows alerts asking if I'm sure I want to delete the sheets and saving


    I tried :
    application.displayAlerts = false
    xls.displayalerts = false

    but It's keeps showing me the alert ...

    any suggestions would be appreciated
    Last edited by orionrafal; 03-15-04 at 12:05.

Posting Permissions

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