calling read only spreadsheets
 

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

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27052

calling read only spreadsheets
 

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
|