ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How clear the cut/copy blinking boxes after macro (https://www.excelbanter.com/excel-worksheet-functions/65156-how-clear-cut-copy-blinking-boxes-after-macro.html)

John

How clear the cut/copy blinking boxes after macro
 
I have macros that do various worksheet copies and they all leave the copy
selection boxes after completion. I can get rid of the solid destination
boxes by just selecting a dummy cell with a command like:
Range("pgmwono").Select, but how to I clear the blinking origin box?

Dave Peterson

How clear the cut/copy blinking boxes after macro
 
application.cutcopymode = false

is one way.

John wrote:

I have macros that do various worksheet copies and they all leave the copy
selection boxes after completion. I can get rid of the solid destination
boxes by just selecting a dummy cell with a command like:
Range("pgmwono").Select, but how to I clear the blinking origin box?


--

Dave Peterson

Bill Kuunders

How clear the cut/copy blinking boxes after macro
 
one way.........

Application.CutCopyMode = False

--
Greetings from New Zealand
Bill K
"John" wrote in message
...
I have macros that do various worksheet copies and they all leave the copy
selection boxes after completion. I can get rid of the solid destination
boxes by just selecting a dummy cell with a command like:
Range("pgmwono").Select, but how to I clear the blinking origin box?





All times are GMT +1. The time now is 12:33 AM.

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