ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 copy sheet with controls not working (https://www.excelbanter.com/excel-programming/416376-excel-2007-copy-sheet-controls-not-working.html)

Bruno Q.

Excel 2007 copy sheet with controls not working
 
Hi, I have a worksheet with controls and shapes objects, when I try
"move or copy", it does not copy these objects. Same thing with only
one shape... Excel 2007 SP1. Anyone experiencing the same behavior?
Thanks.

Bruno Q.

Excel 2007 copy sheet with controls not working
 
On 1 sep, 10:14, "Bruno Q." wrote:
Hi, I have a worksheet with controls and shapes objects, when I try
"move or copy", it does not copy these objects. Same thing with only
one shape... Excel 2007 SP1. Anyone experiencing the same behavior?
Thanks.


Hem... seems that Excel options, advanced tab, Cut, copy, and sort
inserted objects with their parent cells must be checked for the copy
to work... Anyone with the same behavior? Thanks.

jayray

Excel 2007 copy sheet with controls not working
 
On Sep 1, 7:33*am, "Bruno Q." wrote:
On 1 sep, 10:14, "Bruno Q." wrote:

Hi, I have a worksheet with controls and shapes objects, when I try
"moveorcopy", it doesnotcopythese objects. Same thing with only
one shape... Excel 2007 SP1. Anyone experiencing the same behavior?
Thanks.


Hem... seems that Excel options, advanced tab, Cut,copy, and sort
inserted objects with their parent cells must be checked for thecopy
to work... Anyone with the same behavior? Thanks.


I have the experience of not being able to copy or move whole sheets
from one particular workbook to another. I'm also working in Excel
2007. I can't figure out why and have had to resort to just inserting
new sheets in the target workbook and then copying and pasting the
sheets over...

I'll try the Advanced tab settings...


All times are GMT +1. The time now is 10:56 PM.

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