D
Darren
Hi there.
I placed this post on the general Excel user group, before realising
that a specialised prorgramming group such as this may be the better
place. I apologise in advance if you have read this in two places.
I have a shared work book which contains VBA. We have always run it
in
2003.
Recently, we leapfrogged 2007 and went to 2010. It seems that in
shared mode, the VBA is disabled. When I remove shared mode, the VBA
comes alive again.
Is there a setting to correct this behaviour or is this simply the
reality in Office 2010?
Thanks in advance,
Darren
I placed this post on the general Excel user group, before realising
that a specialised prorgramming group such as this may be the better
place. I apologise in advance if you have read this in two places.
I have a shared work book which contains VBA. We have always run it
in
2003.
Recently, we leapfrogged 2007 and went to 2010. It seems that in
shared mode, the VBA is disabled. When I remove shared mode, the VBA
comes alive again.
Is there a setting to correct this behaviour or is this simply the
reality in Office 2010?
Thanks in advance,
Darren