Forum Discussion
Suppressing Office popup when trying to open pdf via excel macros
Hello, (Not an expert at Excel or VBA, by any stretch, but can muddle my way through) I have to create 1000+ forms for individual users and when opening a PDF using macros, a dialog pops up warn...
Perhaps try Application.DisplayAlerts=False right before you open the documents.
Just be sure to turn it back on. Otherwise, it will also suppress the "do you want to save changes" before closing your workbooks, also.
Just be sure to turn it back on. Otherwise, it will also suppress the "do you want to save changes" before closing your workbooks, also.