![]() |
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? |
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 |
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