Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have code that opens the file and activates it:
Workbooks.Open(FileDir & FilesInPath).Activate But I want to combine this with arguments that will open the file as read only: Workbooks.Open(FileDir & FilesInPath).Activate , ReadOnly:=True, _ Password:="Metrics" This line gives me an error "invalid number of arguments". Is it possible to open as active as read-only? Thanks - -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
Excel files opening in "read only" | Excel Discussion (Misc queries) | |||
Activate "current workbook" | Excel Programming | |||
Checking before opening "activate:newwindow" to see if already opened | Excel Programming | |||
"Unable to Read File" on workbook containing Pivot Table | Excel Programming |