Consulting

Results 1 to 3 of 3

Thread: Prevent msg box when deleting a sheet

  1. 07-01-2005, 12:57 PM #1
    Dreamer
    Dreamer is offline
    VBAX Regular
    Joined
    Jun 2005
    Posts
    49

    Prevent msg box when deleting a sheet

    Hi,

    How to write some codes to prevent the display of an alert box when trying to delete any worksheets?

    Thanks for help!
    Reply With Quote Reply With Quote
  2. 07-01-2005, 01:04 PM #2
    shades
    shades is offline
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    DisplayAlerts = False

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    Reply With Quote Reply With Quote
  3. 07-01-2005, 01:56 PM #3
    shades
    shades is offline
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Be sure to enable after you are finished.

    DispalyAlerts = True.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules