| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling clipboard prompt
Hello:
When I close a workbook in a macro, I get a prompt asking "Are you sure? There is a lot of data in the clipboard." How do I disable this prompt? Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling clipboard prompt
Application.CutCopyMode = False
Entered above "End Sub" Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 08:25:54 -0700 (PDT), wrote: Hello: When I close a workbook in a macro, I get a prompt asking "Are you sure? There is a lot of data in the clipboard." How do I disable this prompt? Steven |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling clipboard prompt
You can clear the clipboard before closing:
application.cutcopymode = false 'code to close wrote: Hello: When I close a workbook in a macro, I get a prompt asking "Are you sure? There is a lot of data in the clipboard." How do I disable this prompt? Steven -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling clipboard prompt
Gord/Dave:
Thank you, saves me a whole lot of frustration. S On Aug 15, 12:19*pm, Dave Peterson wrote: You can clear the clipboard before closing: application.cutcopymode = false 'code to close wrote: Hello: When I close a workbook in a macro, I get a prompt asking "Are you sure? There is a lot of data in the clipboard." How do I disable this prompt? Steven -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Override prompt for Office Clipboard | Excel Discussion (Misc queries) | |||
| Office Clipboard empties itself when enabling/disabling commandbars | Excel Programming | |||
| Need to turn off prompt about putting on clipboard or not... | Excel Discussion (Misc queries) | |||
| Disabling refresh data changed PivotTable prompt | Excel Programming | |||
| macro to respond to clipboard prompt? | Excel Programming | |||
Hybrid Mode
