View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mariusz Mariusz is offline
external usenet poster
 
Posts: 3
Default opening workbook as read-only

Many thanks, it works fine
I dont know why I missed it :(

Mariusz

Uzytkownik "Frank Kabel" napisal w wiadomosci
...
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


.