On 10:15 AM 24/09/2001 +0100, Richard Thompson said:
>Hi
>
>Don't know if anyone out there knows of a cure for this simple problem.
>
>I have written a simple VBA Script to process Protel BOMs within excel,
>formatting to a pivot table etc. works well, however,
>
>when it comes to the part where the script is combining cells, excel asks if
>this is ok and if so it will keep only top left hand cell. this is what i
>want, but it asks for every cell! so i have to press enter (or hold) for
>upto several hundred cells.
>
>it does this for clarity. is there a way to turn of the excel check
>dialogue and default to yes for all?
>
>Rich
The Application.DisplayAlerts property may help - check out the on-line help.
Also there is :
Application.Interactive
and
Application.AlertBeforeOverwriting
One of these properties may help.
Ian
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Forum Guidelines Rules:
* http://www.techservinc.com/protelusers/forumrules.html
*
* Browse or Search previous postings:
* http://www.mail-archive.com/[email protected]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
