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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks