Sharing WBs with Macros
 

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

Sharing WBs with Macros
 

I have been tasked with a very similar project and know now that you
cannot delete while a workbook is shared.
Keep it in mind.

Regards
Kristan


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

Sharing WBs with Macros
 

Hi,

So three users changing different sheets, I will assume that the other
departments who look at it only use it for reference and don't change
any thing?

What if you set it up as three seperate workbooks, one for each user.
User1, 2 and 3. User 1 has sheet1 and then in sheet2 and sheet3 you
setup linked references to the other 2 users workbooks with an ontime
event that rechecks the references and adds any new required ones? I
can't test this theory as I can only log onto one pc at the moment.

Any other departsments can then access a read only copy of any of the
three users.

regards,

James

Sharing WBs with Macros
 

Kristan,
Fortunately, I specifically don't want anything deleted, in order t
maintain timelines.
Unfortunately, Excel is not consistant about this sharing restriction
allowing you to delete cell content, if not the cell, row, or colum
itself.



James,
The three (unshared) workbooks idea is good, but the three peopl
support each other, and, at times, will put a comment in each other
sheet.
If the workbooks need to be shared inorder for this to happen, I migh
as well keep them consolidated in one WB.

As for the other departments, I'm thinking I'll make a "public
read-only file that is just a repeater of the actual status WB.

Thanks to both of you,

Kestre

--
Kestrel149

-----------------------------------------------------------------------
Kestrel1492's Profile: http://www.excelforum.com/member.php...fo&userid=2484
View this thread: http://www.excelforum.com/showthread.php?threadid=38399