turning off alerts in VBA

[t16turbo]

I have some code that opens up several worksheets.
I would like to open them all in read-only, as it promtps me for every file.
some are password protected, and some may be open by other users.
how can I acheive this?

 

[bdbBear]

Quick guess is

Application.DisplayAlerts False

... code ...

Application.DisplayAlerts True

 

[PHV]

Have a look at the 3rd parameter of the Workbooks.Open method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886