ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy checkboxes created with Excel97 (https://www.excelbanter.com/excel-discussion-misc-queries/226813-re-copy-checkboxes-created-excel97.html)

[email protected]

Copy checkboxes created with Excel97
 
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
on in order to copy objects.

On Apr 6, 10:18*am, wrote:
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




All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com