Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default 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...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet Currently Challenged ... Excel Discussion (Misc queries) 2 October 8th 09 03:46 PM
Excel 2007 slow to copy entire sheet mjmattox Excel Discussion (Misc queries) 3 March 28th 07 08:30 PM
How can i copy data from a tabbed working sheet to a summary sheet StephenF Excel Discussion (Misc queries) 1 March 15th 07 03:40 PM
Copy sheet problem in Excel 2007 Reinhard Thomann Excel Programming 0 March 7th 07 05:58 PM
Edit / Move or copy sheet stopped working in Excel 2003 kris2u Excel Worksheet Functions 0 October 4th 05 08:20 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"