Problem with sharing a workbook with macro enabale

[sgmpatnaik]

Hi all, Very Good Morning


Kindly suggest when i am going to share a work book then i am getting a message that is given as below: -


"This Workbook Contains Macros recorded or Written in Visual Basic. Macros cannot be viewed or edited in shared workbooks"


Kindly suggest


Hence i Oblige

 

[brijendraydv]

Hi,


Try this it may work,goto tools-macro-security make it low.

 

[sgmpatnaik]

Thank Q So Much


but i am not getting the macro security low option because i am using 2007


so kindly suggest once again

 

[brijendraydv]

Im using 2003 so not sure,anyhow you can go to toolbar there on developer option go to macro setings and then you can disbale all macros.then try and share.let me know

 

[sgmpatnaik]

Well Mr. Brijendraydv ji


I Think it is not correct well let see from our teachers


Thanking You

 

[NARAYANK991]

Hi Patnaik ,


There is no problem here ; this is a feature of Excel and shared workbooks. Check out this link :


http://office.microsoft.com/en-us/excel-help/features-that-are-unavailable-in-shared-workbooks-HP005201080.aspx


I am reproducing a portion of that page here :

[pre]

You can run existing macros that don't access unavailable features.
You can record shared workbook operations into a macro stored in another nonshared workbook.

You cannot write, record, change, view, or assign macros.

[/pre]
Narayan

 

[sgmpatnaik]

Thank Q Sir