| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read Only
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read only file is NOT Read only | Excel Discussion (Misc queries) | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| Read-write/Read-only | Excel Discussion (Misc queries) | |||
| XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Threaded Mode
