Hi all
I can't get rid of the alert "Delete entire sheet row" using DisplayAlerts = False. Here is my code:
Any help much appreciated.![]()
Please Login or Register to view this content.
Hi all
I can't get rid of the alert "Delete entire sheet row" using DisplayAlerts = False. Here is my code:
Any help much appreciated.![]()
Please Login or Register to view this content.
Shall work as it is written. but you can try:
![]()
Please Login or Register to view this content.
Best Regards,
Kaper
I modified (below) with your suggestion and also added a "alerts.false' to the delete column Q line in case that was causing the problem, but still getting the Delete entire sheet row prompt.
Any ideas anyone?
![]()
Please Login or Register to view this content.
Either the problem is within other parts of code, or with the sheet itself (merged cells? protection? event handler? sharing? who knows...).
With simple test sheet I prepared the problem does not occur.
PS. There is no need to disable alerts again - they remain disabled.
Hi Kaper
Thanks for your help. On that basis I messed around with the code a bit and moved the alerts.false statement to various places and finally fixed the problem with the following code:
Thanks again!![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks