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

Excel97 to 2007 3
Convert Legacy checkboxes to PDF 2
Linking checkboxes to multiple worksheets 5
copy text and logo from protected, hidden sheet 1
problems with autofilter and checkboxes 11
Dialog sheet / Checkboxes 3
Cannot copy worksheet to another file 2
Clear CheckBoxes using VBA 3

Top