AnsweredAssumed Answered

vrf Excel columm width

Question asked by fukui.yutaka on Mar 18, 2004
Tapio
The command below will stop alerts being show, but always remember to put them back on after this kind of operation so that files are not deleted by accident.

Application.DisplayAlerts = False or True

Regards,
Phill Griffin
Nokia Mobile Phones
Phone: 01252 867486
Mobile: 07766 513344
www.nokia.com <http://www.nokia.com>



-----Original Message-----
From: ext [mailto:tapio.ronkainen@nokia.com]
Sent: Friday, March 19, 2004 9:10 AM
To: VRF
Subject: [vrf] How to disable this error/requester (on Excel)?


Hello and sorry that I post a Excel question here, but since many of us here use the Excel, perhaps you might have an idea. The Vee is doing 99.9 % of the work in this test, but Excel seems to do equally hard work on generating problems...

The problem is that I need to delete unwanted sheets from my report template (depending test case) automatically. I use the Sheets("Sheet1").delete for this. And the Excel of course gives the "Selected sheet will be permanently deleted..." etc. warning. To disable this requester to pop up, I used the most easiest way. I issue the "On Error Goto 0" command before this delete command, but...

The requester still pop's up.

Since the "On Error Goto 0" works with other cases, like saving on top of the existing file etc. cases there might be something different here.

Easy way to illuminate the problem is to type in the following in Excel's VBA.


Sub Macro()

On Error Goto 0
Sheets("Sheet1").Delete

End Sub


All help is really welcome, I outta my Excel wisdom (not much of it, but...) here.

Thanks, Tapio

---
You are currently subscribed to vrf as: phillip.griffin@nokia.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes