Sheet copy problem Excel 97
Posted by Garland on December 28, 2000 11:14 PM
I have a workbook that creates a new worksheet from a
hidden sheet 'template', when a new employee is added
to the workbook.
As I knew it would, it blew out after copying about
40 records... the dreaded 'sheet 1111111111111...'
copy problem in Excel 97.
I managed to workaround that with a sheet/copy/cells
type macro, which works fine. The only thing I am
stumped on is that the 'copy cells' macro does not
pick up the 'background' bmp image the is attached to
the base worksheet when copying.
Can anyone advise specific code lines to copy the
sheet background from the base sheet to each new sheet
created by the copy macro?
Thanks for any help... Garland