MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Posted by JAF on December 29, 2000 3:00 AM

The code you need is ...
Sub Set_Background_Image()
ActiveSheet.SetBackgroundPicture Filename:="C:\My Documents\paper.bmp"
End Sub

Hope this helps.

Posted by garland on December 29, 2000 8:34 PM


Thank you for your response. However, my goal is to copy the background from 'sheet 1'
not import it from a remote file location.