Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Disabled by 2010 Shared Workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Disabled by 2010 Shared Workbook
It seems that in shared mode, the VBA is disabled.
I tried to reproduce this issue and I found that macros were not disabled for me in a shared workbook. Both in workbooks created in Excel 2003 and 2010 when opened in 2010. I don't see a setting that explains our different results sorry. I knew that the editing of macros in shared workbooks was blocked but not their running. Jim "Darren" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Disable in Excel 2010
Hi,
I am seeing exactly the same behavior as you. Here is my post on about 4 different forums. No one has responded with a solution. I just upgraded to Excel 2010 and noticed the following immediately. When I place an ActiveX control (e.g. a command button) on the worksheet, and then share the workbook, the button does not work any longer (as if it never gets pressed). The control works fine in the un-shared workbook. I do not see this behaviour in Excel 2003 or 2007. Can someone please explain what is happening and a possible solution. I have many Excel 2003 Workbooks with these controls but the buttons do not work when I bring them into Excel 2010 shared workbook. Let me know if you get this resolved. On Tuesday, August 17, 2010 9:08 PM Darren wrote: 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 On Wednesday, August 18, 2010 7:19 AM Jim Rech wrote: I tried to reproduce this issue and I found that macros were not disabled for me in a shared workbook. Both in workbooks created in Excel 2003 and 2010 when opened in 2010. I do not see a setting that explains our different results sorry. I knew that the editing of macros in shared workbooks was blocked but not their running. Jim Submitted via EggHeadCafe - Software Developer Portal of Choice Mocking WCF Services Using Moq http://www.eggheadcafe.com/tutorials...using-moq.aspx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Disable in Excel 2010
Just an idea: can you enable the ActiveX controls via the trust center
in Excel 2010 ? Trustcenter should be somewhere burried in the Options dialog. In Excel 2007 there are specific security options for ActiveX controls in the trust center. Don't know about version 2010. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Macros disabled when workbook is protected (why?) | Excel Programming | |||
Macros in shared Workbook. | Excel Programming | |||
When workbook is reopened, macros are disabled | Excel Programming | |||
Workbook opened with macros disabled | Excel Programming | |||
Excel crashes when attempting to open workbook...even with macros disabled | Excel Programming |