Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using shared "Read Only" program file
EXECUTIVE OVERVIEW: Does anyone know of any issues that could arise from
allowing multiple users to concurrently use a program file set to automatically open "READ ONLY"? I have a file that many users have a copy of. It contains several VBA programs. This program file runs hidden and all programs are executed from toolbar controls. The program file itself is static, the programs only manipulate the file or files the users have active. The program verifies that the correct files are open before executing any functions. Each year a few changes are made and in the past, I have distributed this program by e-mailing it to all users who then save their own copy locally, with instructions to over-write their old version. This method has worked fine for the past three years. Here is my question. Rather than sending out a new version once a year to each individual user, would there be any draw back or problems with changing the program file property to always open "READ ONLY" so that the file could be used concurrently by all the users. I could place ONE copy the file on the network (accessible to all users). The program auto-installs a toolbar when opened and then, as previously stated, all functions are performed only on the user's active files. If you have any ideas, please post back. Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink no picture "No program is regitered to open this file" | Setting up and Configuration of Excel | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
error number to determine if shared file is open on "this" machine | Excel Programming |