| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
recrding macro,copy data thn close file, get messge abut clpbord
While recording a macro I copy data from one spreadsheet and paste to
another. When I close the original sheet I get a message saying the clipboard is full, I'm forced to cancel this command and it locks up the macro when I run it in the main file. How do I turn of this info? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recrding macro,copy data thn close file, get messge abut clpbord
You could add one more line before you close the workbook.
application.cutcopymode = false PaddyBoy wrote: While recording a macro I copy data from one spreadsheet and paste to another. When I close the original sheet I get a message saying the clipboard is full, I'm forced to cancel this command and it locks up the macro when I run it in the main file. How do I turn of this info? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recrding macro,copy data thn close file, get messge abut clpbo
Thanks Dave. I'll try this and see how it runs. I figured there was a
application command. "Dave Peterson" wrote: You could add one more line before you close the workbook. application.cutcopymode = false PaddyBoy wrote: While recording a macro I copy data from one spreadsheet and paste to another. When I close the original sheet I get a message saying the clipboard is full, I'm forced to cancel this command and it locks up the macro when I run it in the main file. How do I turn of this info? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Copying & Filling in data from One file into another. | Excel Worksheet Functions | |||
| Using Relative path for XML data file? | Charts and Charting in Excel | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
