Results 1 to 6 of 6

Capture Add-Delete Worksheet Events

Threaded View

  1. #4
    Forum Contributor
    Join Date
    07-11-2009
    Location
    NYC,USA
    MS-Off Ver
    Excel 2007
    Posts
    135

    Re: Capture Add-Delete Worksheet Events

    I've fixed the Error and have gotten the "ADD SHEET" portion of the code to work.

    I tired using Workbook_BeforeSave but I wasn't sure how to code it.
    I then tried Workbook_Deactivate, but it kept deleting the "INGREDIENTS" sheet.

    I'm at a loss on how to work around this.
    Any ideas?

    There is an updated version of the file attached
    .
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1