Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Read Only
just add 2 commas to the end and a true for read only and you got it.
-- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Jason" wrote: I have some code that opens another workbook. I would like to open the workbood in read only mode regardless of whether another user is in the target workbook, but I do not want the read only prompt box to pop up when the code runs. Can someone please tell my how I can adjust this code so that I will not get the prompt box. Thanks. Set bk = Workbooks.Open(Filename:="P:\Test\Sample Workbook.xls") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA open xls as read-only | Excel Programming | |||
VBA open xls as Read-Only? | Excel Programming | |||
VBA open xls as Read-Only? | Excel Programming | |||
open as read only | Excel Programming | |||
Open as read-only | Excel Worksheet Functions |