Disable Poups

  • Thread starter Thread starter Haarish
  • Start date Start date
H

Haarish

Hi All,

I have a function which I am opening using the ShellExecute method to
Print. I have two issues in doing the same.

1. For password protected files, I am not able to catch the password
protected errors when I enter the wrong password. How do I catch the
error with the above statement?
2. After the file has been printed, since I am using Excel 2007 and
the source files are Excel 2003 - it prompts me asking if I want the
file to be saved. I do not want to save the file always.
Application.DisplayAlerts = False does not work. How do i disable the
save dialog?

Any ideas?

Thanks in advance,
Haarish.
 
Hi,

2. Set the saved property True after the file has been printed.

ActiveWorkbook.Saved = True

Regards,
Per
 
Back
Top