Open Add-In (.xla) workbook as Read Only automatically

R

Ryan H

I have an Add_In workbook that is refrenced by another workbook
(MyWorkbook.xls). When users open MyWorkbook that Add-In opens hidden behind
the scenes. I'd like to have the Add-In automatically open as Read Only
instead of being prompted for a password or click Read Only, is this
possible? Currently, the user has to click Read Only because I have it saved
as needing a password to modify.

Thanks In Advance!!
 
T

Tom Hutchins

Instead of a password to modify, why not set the file's properties to
read-only in Windows Explorer (select the file >> right-click >> Propertiesread-only without a prompt. Also helps to prevent accidental deletion or
renaming of the file.

Hope this helps,

Hutch
 

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 Referenced Add In Workbook as Read Only 5
Open Referenced Add-In Worked as Read Only 1
Why is Add-In (.xla) Workbook Read Only when I try to save? 1
Close Referenced Workbook if it's No Longer Referenced 4
opening a workbook as read only 4
Handling a worksheet calculate event in XLA code 4
Read-only, write-on-demand access to an XLA? 3
Protect a Workbook 3

Top