Hi,
The folks I work with use a single shared workbook as a kind of status
sheet and work turnover. I've been asked to revamp it and and add
several features. These features are easily acheived using a
combination of macros, Until, that is, the file is shared. Sharing the
file kills the buttons I've setup and because of the automation built
into it, makes the file unstable.
So, any Ideas how I can make use of macros while to file is shared, or
achieve the same results without sharing?

Details:
- Three people use the same shared file. The sharing option updates
the file by autosaving every 15 mins. *Constant updating is a necessary
function of this file.*
- Each person has their own sheet within the WB, but refers to the
other sheets constantly.
- Multiple departments "easedrop" or access the file, on and off, all
day.
- The file is archived daily and renamed to reflect the new date(Ex:
06-30-05.xls). This is one of the automated features I must keep.
- The file is extremely safety sensitive, and must remain stable.
- I have only just begun exploring the methods used in menumakr.xls,
and I don't know what it will, and won't, do when shared.
- The users of the file are not Excel power users in the slightest.
- Yes, I know, but ACCESS is not available for use.

Any Ideas?
Need more information?

Thanks,

Kestrel


--
Kestrel1492


------------------------------------------------------------------------
Kestrel1492's Profile: http://www.excelforum.com/member.php...o&userid=24849
View this thread: http://www.excelforum.com/showthread...hreadid=383990