I've got an app which is written in VBA. The app is password
protected against modifications, so when users open it, Excel comes up
with message 'm-portal is reserved by Saul Margolis. Enter password
for write access, or open read only.' Some of the users have been
entering their application passwords in this box.

I was wondering whether there is a way to tell Excel to open read only
without bringing up that dialog box - perhaps a parameter to
excel.exe?

Thanks in advance,
Saul

I always used windows explorer to make the files readonly.

Then excel wouldn't even bother asking how to open it.

Maybe it'll work for you, too.

Saul Margolis wrote:

I've got an app which is written in VBA. The app is password
protected against modifications, so when users open it, Excel comes up
with message 'm-portal is reserved by Saul Margolis. Enter password
for write access, or open read only.' Some of the users have been
entering their application passwords in this box.

I was wondering whether there is a way to tell Excel to open read only
without bringing up that dialog box - perhaps a parameter to
excel.exe?

Thanks in advance,
Saul

--

Dave Peterson

Nice one!!! That worked 100%. Thanks.