Tuesday, 22 June 2010

Removing alert Messages in VBA

I had written a VBA script that copied information from one workbook to another, every time the info was copies an alert popped up that had to be confirmed. This was tiresome to say the least, after much research and a little help form the Microsoft Forums writing the line

Application.DisplayAlert = False

just before the 'paste' command prevents this alert from popping up.

No comments:

Post a Comment