close

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--
mudraker
------------------------------------------------------------------------
mudraker's Profile: www.excelforum.com/member.php...foamp;userid=2473
View this thread: www.excelforum.com/showthread...hreadid=537065The 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.

Brendan Vassallo wrote:
gt;
gt; Hi All,
gt;
gt; I am using XL 2000 and have a workbook that contains several macros. I
gt; would like to make this workbook a shared workbook, however I remeber
gt; something along the lines that you cant share a workbook with macros on it
gt; and I dont want to share the workbook and corrupt the file.
gt;
gt; Can anyone please let me know if it is possible to share the workbook and if
gt; so will the macros still work?
gt;
gt; Thanks
gt;
gt; Brendan

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()