Macro button copies sheet containing a macro button as an image

[namso1902]

I am trying to create a macro button that will copy an entire sheet containing that macro button each time it is activated. However rather than copy the sheet and displaying it as the original sheet, it is copied as an image and data cannot be entered into it.

I have attached the spreadsheet. Its the "Cust Account" sheet which is the problem.

Anyone know why this occurs.

Regards.

[Sean Thomas]

i used this and it adds an exact copy

Please Login or Register  to view this content.

[namso1902]

Thanks for the VBA macro code. It works.