ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   new xlsm & VBA problem (https://www.excelbanter.com/excel-programming/444250-new-xlsm-vba-problem.html)

Karol

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?



All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com