General discussion

Locked

Copy Paste in XP

By Topic ·
I know this supposed to be kids play and no big deal to copy and past but here is the challenge.

I need to copy the Value contents of one worksheet in a workbook(sourcefile) to another Workbook/Worksheet (Destination). No probs so far

The Source file appart from the ususal array of formatting, also has buttons that activate a Macro.

The PROBLEM. When I select the range>Click Copy>Paste everythings copies perfectly except the buttons. How can I get the buttons to also copy accross.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by EdLockett In reply to Copy Paste in XP

You can copy the buttons across by themselves. Click on them one by one, holding down CTRL. Then use the copy command. They are not included when you select a range.

Collapse -

by Topic In reply to Copy Paste in XP

Topic - Thank you for your response but that is not practical, as I will have to do this for 20 worksheets every week.. This is not the solution I was looking for.

Copy/Paste within the same workbook copies the buttons across, but does not do so from one workbook to another.

I can not use the copy/move Worksheet function either, as the destination Workbook has hard coded functions that will try to access existing (blank) worksheets within the Destination Workbook.

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums