Macro on shared workbook

Hi All!

Can anyone plz tell me tht how to write or record macro on a shared workbook?

1st I had to keep the workbook unshared, then I recorded, checked then made again 'shared workbook', then checked my macro. The macro is working fine, but plz tell me is this method fine or have some risk? ..I would like to be know the other ways of making macros for a shared workbook, plz help!

Thanks in Advance!

You can not change/edit/write/record macros in a shared workbook. The only way is to unshare the workbook, create/edit your macros, then share the workbook again.

After that, sit back and wait for the workbook to start acting funny, losing settings, losing data, throwing errors.

This will eventually occur.

Avoid shared workbooks.

What would be the point of sharing the workbook if the users can't edit it?

When you open Excel, the program automatically opens all files that are in the XLSTART directory.

IF you create a workbook, with all your code in it, hide it and then put it in the XLSTART directory, your code will be available over all your workbooks.

Put copies of this code workbook in everyone's individual XLSTART directories and they will have access to the macros.

As mentioned above, shared workbooks are a bit screwy, so try and stay away from them.

You mean to C:\Program Files\Microsoft Office\OFFICE11\XLSTART (folder) ??

I've got some knowledge frm below link:
http://www.bettersolutions.com/excel/EHN113/QA748890521.htm

Locate the following folder:

* Excel 2007:
C:\Program Files\Microsoft Office\OFFICE12\XLSTART
* Excel 2003:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART

..but in my PC this XLSTART folder is empty.

Yeah, well, if those folders are empty, then that just means that currently no files are automatically opened when you start Excel. If you save/copy a file to this folder, then it will be opened when Excel is started.

I'm not sure I'd be happy with distributing a file to a group of people, hoping they will put it in the correct XLSTART folder, though. It will be a maintenance nightmare.

If you need an application that supports simultaneous edit access by multiple users, Excel is not the right tool. You should be looking into a database solution instead.

If you want to distribute an Excel-file, containing macros, that you want to be stored in the xlstart-folder on the recipients system you could use:

Please Login or Register  to view this content.

Thanks alot Mr. teylyn and snb

...but if u can check out below attached workbook for an example, then wher should I paste/ write the given codes in the workbook, before placing in the every teammates PC's XLSTART folder directory?

(Can I keep protected Macro codes, then put the workbook in the XLSTART folder directory?)

Plz put some light on it for me...

Thanks in Advance!

Please Login or Register  to view this content.

means: put this into the workbook module.

Originally Posted by teylyn

If you need an application that supports simultaneous edit access by multiple users, Excel is not the right tool. You should be looking into a database solution instead.

You mean to Database Management System (DBMS)??

Thanks for telling me, I'll sure start learning it too.