Results 1 to 11 of 11

Thread: Solved: Mysterious macro running on Excel file close?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    VBAX Newbie
    Joined
    Mar 2011
    Posts
    4
    Location
    Thanks for the quick reply!

    Oh well. It looks like there's a 1 meg limit to it, so I zipped it. I send you an empty version, but you will still get that message when you close the file. and then if you find the cause fix it I can replicate the same in the original file.

    Also, I just noticed that there is a buch of unknown lists - that is why the file is so big even without any obvious content in it.. Do you know of any VBA code to remove ALL lists en-masse?

    Thanks!
    Dan




    Quote Originally Posted by mdmackillop
    Possibly something in Personal.xls or an add-in?
    Can you clear any data and post your workbook? (Manage Attachments in Go Advanced Reply section.)
    Attached Files Attached Files

Posting Permissions

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