Copying sheets with pictures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a worksheet which contains quite a lot of information, including many
VBA buttons, pictures and 59 charts. I have turned off Auto font size for
charts in the Windows register, because otherwise it complained that I had
too many fonts. I want to make 36 copies of this worksheet in the same
workbook, but when I try to copy it, all the VBA buttons, pictures and charts
are missing in the new spreadsheet!
Neither copying via the Edit menu, or selecting everything and copying with
ctrl+C works. What should I do?

Thank you,
Sebastian
 
Right click on the sheet's tab and choose Move or Copy. Check the Make a
copy box. Repeat as needed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying embedded charts 1
Picture Links printing problem - Help! 1
Copying a Picture From Cell Comment 0
Custom Headers 1
no more new fonts may be applied in this workbook... 2
Charts don't copy with new sheet 9
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Copying Excel 2007 Charts as picture (as seen on screen) 1

Back
Top