Off'97
I have a VBA macro that calculates values from several sheets and and
updates a summary sheet (basically a template but is left as an "XLS" for a
variety of reasons). On the summary sheet there is a command button that
calls a routine to create a new workbook and copy some selected sheets as
well as the summary sheet to that book.
Because I wanted to remove the button from the copied summary sheet I did it
by

NewBk.Worksheets("Summary").Shapes("cbSaveStmnt"). Select
Selection.Cut

Immediately after this code I save the new workbook with a new name (Year
and month).

All is well, except, if I do a print preview on the displayed summary sheet
(the last sheet copied) Xl goes "boom" and tells me it was referencing a
memory location that couldn't be read.

I played with it and found that if I selected another sheet in the same book
and immediately re-selected the summary it was ok on a preview.
Further, if I rem'd out the button cut statement it was ok.

Incidentally (or maybe not so incidental), the whole project was created
between Off 2000 and '97. It will be installed on a '97 m/c.

I can't seem to duplicate the problem on 2000 (is there some sort of
conflict between the two versions?)

Any ideas?

--
Regards;
Rob

Please reply to the NG.
I'm already up to my eyeballs in
Nigerian/South African get rich
letters as well as "Microsoft Critical Updates" et al.