clean up the code so it doesn't do any selecting.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
I have a workbook with about 15 sheets, and a bit of VB code running
some pivot tables. The whole workbook is rather large (23mb) as this
analyzes about 30k records.

The problem happens when I try to "Save As". While the book saves fine,
the "save as" function gives me many runtime errors on various bits of
code. When I click debug on the errors, it always highlights a line
which refers to a 'selection'(copy, paste, etc.). The lines which cause
the errors vary depending on which sheet is active at the time- ie, the
code behind a certain page will not throw any errors if that sheet is
active at the time, but the other pages will. I have taken out all
activesheet and activecell references, but these selection commands are
giving me trouble. It's as if each page's code is fully running
everytime I click "Save As".

Normally this would not be a problem, but this is a template for other
users and they will all be needing to "Save As". Any ideas?