good time of a day everyone!
could pls anyone advise why a macros I recorded in my xls file wouldn´t work on other PC (the user has the same version of the excel - 2010).
the code is simple - I added the ¨forms control button¨(not ActiveX controls) and recorded a macros that copies info from certain columns and pastes the content as values in different columns. I was using the recorder, tried saving it both in personal macrobook and ¨this workbook¨only, even äll open workbooks¨. the code is as follows:
Sub ivansamsonov()
'
' ivansamsonov Macro
'
'
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 12
ActiveWindow.ScrollColumn = 13
Columns("AM:AS").Select
Selection.Copy
Columns("Q:W").Select
Application.Run "PERSONAL.XLSB!Macro11"
ActiveWindow.ScrollColumn = 12
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("Q2").Select
End Sub
then when I send it to my colleague and try using this macro button I get an error declaring that the path to the macro is not found or smth like that. I also tried saving the xls file as ¨macro enabled¨format, nothing works, others can´t use it. can anyone help me with this? really important trick to master for me. many thanks in advance!
cheers
Bookmarks