Shared Workbooks with Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am using XL 2000 and have a workbook that contains several macros. I
would like to make this workbook a shared workbook, however I remeber
something along the lines that you cant share a workbook with macros on it
and I dont want to share the workbook and corrupt the file.

Can anyone please let me know if it is possible to share the workbook and if
so will the macros still work?

Thanks

Brendan
 
Brendan

You can share workbooks with macros

The macros will run as normal for each person.

You can not modify the macros in a shared workbook
 
The macros will still work--but you can't edit them when the workbook is shared.

To be more honest, the macros MAY work. It depends on what they do. There are
lots of features that are unavailable in shared workbooks. You'll want to do
some testing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Shared Workbooks with Macros 1
Eliminate macro warning when you open a workbook 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Macro-enabled Workbook 2
Macros in Shared Workbook 6
Shared Workbook UserForms 2
Multiple Workbooks using same macro 4

Back
Top