| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Boxes | Excel Discussion (Misc queries) | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
| Macros to delete check boxes | Excel Discussion (Misc queries) | |||
| Using a Macro to clear out check box seletions | Excel Worksheet Functions | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
Linear Mode
