Check out the ReadOnly parameter of the Workbooks.Open method in VB help.

--
Jim Rech
Excel MVP
"scottwilsonx" wrote in message
...
|
| Hi, I have a master spreadsheet that calls a number of spreadsheets from
| a simple menu system.
|
| The point is that each of the master spreadsheets are currently set for
| "read only", and the user needs to specify that they are happy to load
| as read-only.
|
| Using VBA, or any other way, is it possible to set the spreadsheets so
| that when they load they are "read only" but the user does not have to
| click a button to confirm the fact.
|
| Thanks for any assistance.
|
| Scott.
|
|
| --
| scottwilsonx
| ------------------------------------------------------------------------
| scottwilsonx's Profile:
http://www.excelforum.com/member.php...o&userid=11128
| View this thread: http://www.excelforum.com/showthread...hreadid=270526
|