Read Only msg

G

Gisela

I have a macro that is called from different workbooks. This macro hides
unused rows. It was define as Sub HideRow() in Module 2 of Entity_LOB_PST
file.

If more than one person is calling the macro from different workbooks, they
get a message “file is being used by another userâ€.

The macro is called from the different workbooks using the following
statement:
Application.Run "'" & Path2 & "Entity_LOB_PST.xls" & "'!HideRow"
where Path2 is the location of file Entity_LOB_PST

Is there any way to eliminate this message an open the macro as read only?
Please, help!
 

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

Read Only 3
Read Only now different 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Active Content in this file is blocked issue 1
Save workbook without shapes 0
Run code from another workbook 7
Variable causing subscript out of range error 1
Remove "read-only" from Publisher file 0

Top