Macro issues with Office 2010 vs 2007

[alexaronson]

Hello and thanks for looking at my question.

I have a tool that I developed for use within my office using Office/Excel 2007 which is now expanding into other off site teams. However, when posting the file on the Shared Drive for them to access it, some users who have Office 2010 are having issues where as the folks who have Office 2007 are not.

Has anyone seen this issue before? If so, is there a quick fix?

Thanks,

 

[Norie]

What 'issues'?

 

[alexaronson]

Norie,

Glad to see that you are alive and well.

My spreadsheet have two drop down list boxes. Cells A2 and A4 that fire off a macro when the user changes the drop down.

The Macro linked to cell A2 recalculates the list for A4. Once the user changes A4, the real work beggings and data is displayed below.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False

Select Case Target.Address
    'NAM Changes triggers macro to create a list of brands for the NAM
    Case "$A$2"
        Call NamShortList
      Case "$A$4"
        Call CreateData
      'When changed, this macrco recreates the variance between TPM and the
    'Key Figure selected
End Select
Application.EnableEvents = True


End Sub

My users can see the drop down box, but when they change cell A2, nothing happens. Thus A4 is not refreshed and my users cannot see the data that they want.

 

[alexaronson]

Apparently Office 2010 does not like accessing a macro with the following line:

Call NamShortList

I changed the code to access the macro with

Application.Run "'WMT Fcst POS.xlsm'!NamShortList"