calling read only spreadsheets

[scottwilsonx]

Hi, I have a master spreadsheet that calls a number of spreadsheets fro
a simple menu system.

The point is that each of the master spreadsheets are currently set fo
"read only", and the user needs to specify that they are happy to loa
as read-only.

Using VBA, or any other way, is it possible to set the spreadsheets s
that when they load they are "read only" but the user does not have t
click a button to confirm the fact.

Thanks for any assistance.

Scott

 

[Jim Rech]

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

--
Jim Rech
Excel MVP
|
| 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?action=getinfo&userid=11128
| View this thread: http://www.excelforum.com/showthread.php?threadid=270526
|