| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy 2007 created macro to run in 2003 | Excel Discussion (Misc queries) | |||
| cannot copy newly created files to backup, all existing ok | Excel Discussion (Misc queries) | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
| Copy checkboxes to another sheet | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Linear Mode
