If you use windows explorer to mark the file as readonly, excel will see this
and not even offer the user a choice.

Same thing if you the file is on a server that the user only has read access.

If those are not possible, you could use another workbook that contains a macro
that would open your file whichever way you want.

(You did mean you password protected the workbook (not the worksheet), right?)

Acube wrote:

Hi, I created a passwords to protect my worksheet. So not it can only be
open as read-only. By everytime, it will pop-up a window asking me to
key-in passwords or choose read-only. Is there a way to by-pass this
and open as read-only each time?

--
Acube
------------------------------------------------------------------------
Acube's Profile: http://www.excelforum.com/member.php...o&userid=29734
View this thread: http://www.excelforum.com/showthread...hreadid=494453

--

Dave Peterson