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 permanently delete the date, Press Delete"


my code is

Please Login or Register  to view this content.

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

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
>
>

how do you clear the clipboard via vba

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

...........

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