Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
supressing a message in vba
Hi
I have a button to export and cut rows to another spreadsheet. Excel promts me on moving the rows that I have named ranges on the sourcesheet with the same names as on the destination sheet. Would I like to keep the names the same or change them? I always want to keep the named ranges the same so that the rows when added will work the same as they will contain the same data in the named ranges. Can someone tell me how to stop the messages? Thanks Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
supressing a message in vba
Try
Application.DisplayAlerts = False ' your code here Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Rob Hargreaves" wrote in message ... Hi I have a button to export and cut rows to another spreadsheet. Excel promts me on moving the rows that I have named ranges on the sourcesheet with the same names as on the destination sheet. Would I like to keep the names the same or change them? I always want to keep the named ranges the same so that the rows when added will work the same as they will contain the same data in the named ranges. Can someone tell me how to stop the messages? Thanks Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
supressing a message in vba
Thanks Chip thats a great help
"Chip Pearson" wrote in message ... Try Application.DisplayAlerts = False ' your code here Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Rob Hargreaves" wrote in message ... Hi I have a button to export and cut rows to another spreadsheet. Excel promts me on moving the rows that I have named ranges on the sourcesheet with the same names as on the destination sheet. Would I like to keep the names the same or change them? I always want to keep the named ranges the same so that the rows when added will work the same as they will contain the same data in the named ranges. Can someone tell me how to stop the messages? Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use AutoFilter without supressing rows ? | Excel Discussion (Misc queries) | |||
Supressing the Macro security message programmatically. | Excel Programming | |||
Supressing CHR13 or vbCr write in text file | Excel Programming | |||
Supressing Update Links Dialog Box | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |