Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I get excel to read open office spreadsheets? | Excel Discussion (Misc queries) | |||
opening read only spreadsheets using windows vista | Excel Discussion (Misc queries) | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003. | Excel Worksheet Functions |