Excel should allow macro on a shared workbook.
 

We are using excel tables all the time at my company. There are more than 20
people working on the same excel file which has thousands of columns so we
use autofilter or some other macros.
Shared workbook will help us alot because we will be able to change the file
at the same time which is very time saving.
Is there any way that macros are allowed at shared workbooks?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

You can run macros on shared workbooks.

You can't edit them, but you can run them.

And somethings can't be done in shared workbooks--even by macros.

Sahin wrote:

We are using excel tables all the time at my company. There are more than 20
people working on the same excel file which has thousands of columns so we
use autofilter or some other macros.
Shared workbook will help us alot because we will be able to change the file
at the same time which is very time saving.
Is there any way that macros are allowed at shared workbooks?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson