Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Problem with copy and paste together with macros

I am working on a customers excel file.

Currently, when I copy a cell, it gets selected. When I click on any other
cell to
paste, the selected cell loses it's selection, and I cannot Paste.

When I disable the Macros, I don't have this problem.

Any idea what the macros could be enabling or disabling to cause this.

Thanks.

Paul van coller
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 459
Default Problem with copy and paste together with macros

Camper Joe wrote:
I am working on a customers excel file.

Currently, when I copy a cell, it gets selected. When I click on any
other cell to
paste, the selected cell loses it's selection, and I cannot Paste.

When I disable the Macros, I don't have this problem.

Any idea what the macros could be enabling or disabling to cause this.

Thanks.

Paul van coller


Hi Paul,

Maybe there's some event driven macro that disable the copy and/or pasting
on that sheet. Right click on the sheet tab and select View Code. Then you
can see if there is any event driven macro on that sheet.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Problem with copy and paste together with macros

You have another response at your other post.

Camper Joe wrote:

I am working on a customers excel file.

Currently, when I copy a cell, it gets selected. When I click on any other
cell to
paste, the selected cell loses it's selection, and I cannot Paste.

When I disable the Macros, I don't have this problem.

Any idea what the macros could be enabling or disabling to cause this.

Thanks.

Paul van coller


--

Dave Peterson
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
Copy and Paste Problem Skc Excel Discussion (Misc queries) 1 March 8th 06 07:21 PM
Copy and Paste Macros dickives Excel Discussion (Misc queries) 0 January 20th 06 08:49 PM
copy paste problem? Neil22 Excel Discussion (Misc queries) 5 January 10th 06 05:32 PM
Excel cut/Paste Problem: Year changes after data is copy and paste Asif Excel Discussion (Misc queries) 2 December 9th 05 05:16 PM
Creating a macros to copy and paste cells Karin Schmidt Excel Discussion (Misc queries) 1 August 4th 05 07:07 PM


All times are GMT +1. The time now is 01:11 PM.

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

About Us

"It's about Microsoft Excel"