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.
0 comments:
Post a Comment