Opening password protected sheets using VBA

[t16turbo]

Hi there,

if I use Workbooks.Open on a password protected sheet - it brings up a prompt for a password or Read-Only option.
I've disabled the alerts, but the box is still displayed.
does anyone know how I can open this always in read-only?

 

[GlennUK]

Have ,ReadOnly:=True option on your Open statement.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

Hey t16turbo,

did you post this query twice??????

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.