opening workbook as read-only

  • Thread starter Thread starter Mariusz
  • Start date Start date
M

Mariusz

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
 
Hi
try
workbooks.open filename:=your_filename.xls, readonly:=True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Add-In (.xla) workbook as Read Only automatically 1
Open Referenced Add In Workbook as Read Only 5
Macro to open a workbook as read only 2
Protect each worksheet individually 4
Protect a Workbook 3
opening a workbook as read only 4
Excel prompts for VBA password when opening 5
Linking to Password-required-to-open workbooks 2

Back
Top