Sharing a Workbook

M

Moe

I'm hoping someone can help me with this. I designed a finance matri
for the company I work for so that the phone reps are able to decid
whether or not an applicant qualifies for a credit card.
The spreadsheet has a bunch of macros, drop down lists, and such. I
is important that I track every 'set' of information that is keyed in.
Right now, I have a button called "Submit" and it takes the info tha
was keyed in, and stores it in another 'hidden' sheet in the workbook.
I have 20 copies of the workbook, one for each employee. The proble
arises when I need to make changes to the file, or the the vba code,
have to do it 20 times. Is there an easier way to do any of this? An
this leads me to another question, is there a way to store a macro on
network drive so that I only have to change that one file, and not 20?
Any help is appreciated.
Thanks
Mo
 
F

Frank Kabel

Hi
only some general ideas:
- have you tried 'sharing' your workbook ('Tools - share workbooks).
Drawback: limited functionality
- You can create an add-in, place this in a network location and
install it for every PC linking this network location

But in general this sounds more like a database application :)
 
Top