Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
I've got a project that uses a Master workbook and subsequently copies a
worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
Application.DisplayAlerts = False
Sheets("YourSheet").Delete Application.DisplayAlerts = True Charles Chickering Jeff Harbin wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
application.enablealerts = false
'delete your sheet application.enablealerts = true -- HTH... Jim Thomlinson "Jeff Harbin" wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
application.displayalerts not enablealerts... Sorry. I must be losin' it...
application.displayalerts = false 'Delete your sheet application.displayalerts = true -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: application.enablealerts = false 'delete your sheet application.enablealerts = true -- HTH... Jim Thomlinson "Jeff Harbin" wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
Thanks all. That worked.
"Jeff Harbin" wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
Application.Displayalerts = False
worksheets("TempData").Delete Application.Displayalerts = True -- Regards, Tom Ogilvy "Jeff Harbin" wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Sheet w/o warning prompt...
one of those days, huh jim<g
-- Gary "Jim Thomlinson" wrote in message ... application.displayalerts not enablealerts... Sorry. I must be losin' it... application.displayalerts = false 'Delete your sheet application.displayalerts = true -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: application.enablealerts = false 'delete your sheet application.enablealerts = true -- HTH... Jim Thomlinson "Jeff Harbin" wrote: I've got a project that uses a Master workbook and subsequently copies a worksheet from 1 of 10 different workbooks, runs some calculations on the summary, and then deletes the worksheet that I rename 'TempData'. I rename the imported sheet 'TempData' to maintain consistency in the code since the data compilation is the same for each of the 10 different sheets imported. I've got it set up so that it will copy the sheet over to the Master workbook and run the calculations and then Delete the imported sheet 'TempData'. The problem I'm experiencing is that I get the prompt telling me that any data on that sheet will be lost and am I sure I want to delete this sheet. That makes an long automated process required user interaction 10 times to acknowledge the deletion of the 'TempData' sheet. Can I force EXCEL to delete the sheet w/o the warming prompt? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Delete Excel Sheet without Warning - MFC | Excel Programming | |||
VBA Bypass Delete Sheet Warning | Excel Programming | |||
What is the VBA code to delete a sheet without warning message? | Excel Discussion (Misc queries) | |||
Delete sheet without prompt | Excel Programming | |||
Delete sheet without warning messages | Excel Programming |