Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
How do I stop excel from give this message by answer for my users? "Data may exist in the sheet(s) selection for deletion. To permanentl delete the date, Press Delete" my code is Code ------------------- Sub CopyCells() Range("A1:I15").Select Selection.Copy Sheets.Add ActiveSheet.Paste Sheets(1).Select Sheets(1).Name = "LeaveRequest" Cells.Select Application.CutCopyMode = False With Selection.Interior .ColorIndex = 2 .PatternColorIndex = xlAutomatic End With ActiveWindow.DisplayHeadings = False Sheets("LeaveRequested").Select ActiveWindow.SelectedSheets.Delete Range("l9").Select End Sub ------------------- -- cedtech2 ----------------------------------------------------------------------- cedtech23's Profile: http://www.excelforum.com/member.php...fo&userid=3102 View this thread: http://www.excelforum.com/showthread.php?threadid=56368 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
Try this...
Sub CopyCells() Application.displayalerts = false Range("A1:I15").Select Selection.Copy Sheets.Add ActiveSheet.Paste Sheets(1).Select Sheets(1).Name = "LeaveRequest" Cells.Select Application.CutCopyMode = False With Selection.Interior .ColorIndex = 2 .PatternColorIndex = xlAutomatic End With ActiveWindow.DisplayHeadings = False Sheets("LeaveRequested").Select ActiveWindow.SelectedSheets.Delete Range("l9").Select Application.displayalerts = true End Sub Duncan cedtech23 wrote: How do I stop excel from give this message by answer for my users? "Data may exist in the sheet(s) selection for deletion. To permanently delete the date, Press Delete" my code is Code: -------------------- Sub CopyCells() Range("A1:I15").Select Selection.Copy Sheets.Add ActiveSheet.Paste Sheets(1).Select Sheets(1).Name = "LeaveRequest" Cells.Select Application.CutCopyMode = False With Selection.Interior .ColorIndex = 2 .PatternColorIndex = xlAutomatic End With ActiveWindow.DisplayHeadings = False Sheets("LeaveRequested").Select ActiveWindow.SelectedSheets.Delete Range("l9").Select End Sub -------------------- -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563680 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
data you have copied remains on office clipboard
clear the clipboard -- hemu "cedtech23" wrote: How do I stop excel from give this message by answer for my users? "Data may exist in the sheet(s) selection for deletion. To permanently delete the date, Press Delete" my code is Code: -------------------- Sub CopyCells() Range("A1:I15").Select Selection.Copy Sheets.Add ActiveSheet.Paste Sheets(1).Select Sheets(1).Name = "LeaveRequest" Cells.Select Application.CutCopyMode = False With Selection.Interior .ColorIndex = 2 .PatternColorIndex = xlAutomatic End With ActiveWindow.DisplayHeadings = False Sheets("LeaveRequested").Select ActiveWindow.SelectedSheets.Delete Range("l9").Select End Sub -------------------- -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563680 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
how do you clear the clipboard via vba -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563680 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
Cedtech23:
Does disabling alerts not solve the problem as my post above? Duncan cedtech23 wrote: how do you clear the clipboard via vba -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563680 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data may exist in the sheet(s) message
...........
http://groups.google.co.uk/group/mic...1e183cf0674882 ........ Duncan Duncan wrote: Cedtech23: Does disabling alerts not solve the problem as my post above? Duncan cedtech23 wrote: how do you clear the clipboard via vba -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563680 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Make a new sheet if it doesn't exist | Excel Discussion (Misc queries) | |||
VBA, Make a new sheet if it doesn't exist | Excel Discussion (Misc queries) | |||
Checking that file exist and if not display a message | Excel Programming | |||
Does the sheet exist? | Excel Programming | |||
Does sheet exist? | Excel Programming |