Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prompt for Delete Sheet (Excel 2003)

    How do I turn on the prompt that used to ask if I really wanted to delete a worksheet? Since Delete is so close to Rename on the menu, I often choose Delete by mistake. And once you delete a sheet, it's gone forever!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Prompt for Delete Sheet (Excel 2003)

    Does this work?

    Goto VB (alt-F11)
    ctrl-g (Immediate window)
    (enter in the window
    Application.displayalerts = true<enter>
    Alt-Q (quit VB)

    Steve

Posting Permissions

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