Results 1 to 4 of 4

Thread: [RESOLVED] Deleting a Tab in Excel

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Posts
    406

    [RESOLVED] Deleting a Tab in Excel

    I can delete a sheet in Excel with code, but a popup comes up telling me that 'data' may be lost if the tab is deleted...

    is there a way to delete the tab and avoid the popup?

    Here is what I have:

    Code:
    With Sheets(i)
          .Select
          .Unprotect
          .Delete
    End With
    thanks in advance!
    Last edited by jeffcravener; Dec 2nd, 2003 at 09:13 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width