Results 1 to 12 of 12

Thread: Save a copy solution

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,476
    Location
    Quote Originally Posted by L@ja
    sorry, my code was really wrong :-(
    It's called the learning process

    BTW, when you run code which will trigger the Event macro, add the line
    Application.EnableEvents = False
    at the start, resetting to True at the end. This prevents the loop.
    Last edited by Aussiebear; 03-03-2025 at 03:34 AM.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

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