View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default opening workbook as read-only

Hi
try
workbooks.open filename:=your_filename.xls, readonly:=True

-----Original Message-----
Hi,
I've got workbook with write access password. I want

to open it as
read-only from another workbook using VBA. How to make it

to prevent
appearing prompt to input password? (I dont want to

press "read only" button
in this prompt?

Regards
Mariusz


.