Shared Workbook Marcro's

[Snowman58]

I have a project that Must be Shared according to the customer.

I re-wrote the project to eliminate changing protections, shut off all the error trapping etc. to address the limitations of sharing.

The top sheet has a set of buttons to call up various data entry sheets, however as soon as I turn on sharing none of the buttons respond. No error messages, just no response. Works fine with sharing turned off.

Here is an example of the button code that does not respond.

Private Sub CommandButton1_Click()  ' Show AWSO 1
    OpenSheet "AWSO1", "D1"
End Sub

Suggestions on how to track this down?

Thanks!

 

[Andrew Poulsom]

It seems that ActiveX controls are disabled in a shared workbook in Excel 2010. Have you tried a Form Controls CommandButton?

 

[Andrew Poulsom]

Actually it works for me in version 14.0.7116.5000 (32 bit), so the issue appears to have been fixed.

 

[Snowman58]

It is not working on either a 2003 or a 2010 machine.

 

[Andrew Poulsom]

If it's an xlsm it won't work in Excel 2003.

 

[Snowman58]

If it's an xlsm it won't work in Excel 2003.

It is an xls workbook originally created in 2010 using compatibility mode.

I recreated the project using 2003 and it seems to be working. Out to the customer for validation.

 

[Snowman58]

Correction - Seems to be working when Shared only applies to 2003.

Still does not work in 2010 if Shared, (works fine if NOT Shared). All trust center security is shut off/trusted/etc.

Not even a simple button response macro shown in first post above.

Really would appreciate any guidance on this!

 

[Andrew Poulsom]

What version of Excel 2010 do you have?

 

[Snowman58]

What version of Excel 2010 do you have?

Shows: 14.0.4734.1000
Also says no updates available.

 

[Andrew Poulsom]

That's odd as I have version 14.0.7116.5000 (32 bit), which would appear to be later than yours.