Copy checkboxes created with Excel97

D

decclt

I have many spreadsheets that contain checkboxes and pictures (logos)
that were created with Excel97. With Excel97 I was able to copy and
paste the entire worksheet using the right click context menu of the
worksheets tab. When I try to copy a sheet with Excel 2007 the
checkboxes and logos do not copy. I have messed with the Trust Center
settings but to no avail. How can I fix this?

TIA!

BrianG
 
D

decclt

Found a configuration setting that was causing the problem. In Excel
Options|Advanced|Cut,Copy,Paste section the "Cut, copy and sort
inserted objects with their parent cells" setting needs to be enabled
 

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

Need Help with Macro Security 1
Copying and pasting checkboxes 4
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Convert Legacy checkboxes to PDF 2
Auto Refresh data from original worksheet to newly created copy 0
Copy worksheet to new doc w/formulas not referencing previous doc 4
strange issue with excel97 on one PC 1
old files print correctly in excel97 but light gray in excel2003 0

Top