View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karol Karol is offline
external usenet poster
 
Posts: 1
Default new xlsm & VBA problem

I have same Excel 2003 books wiith VBA programming and thise books have
buttons with macros in this way: Book1!'GetMyData 10, 100'

For instance:
Sub 'GetMyData (A, B)
Msgbox "Yours Numbers: " & A & ', " & B
End sub

This macro goes with out problems in Excel 2003 and in Excel 2010 as xls
file.
The problem started, when I want transform xls file into xlsm file (in Excel
2010).
During this transformation Excel 2010 says about errors and finally give me
buttons with macros in this way: Book1!_GetMyData_10__100_ (!!!)
What's the matter?