vba - How to prevent an *unwanted* modification of a macro address -
environment: windows 7, excel 2010, dropbox
in workbook.xlsm have assigned button address of macro.
as long stay in same computer, macro executed when "press" button.
the same button in same workbook, accessed on computer related via dropbox, not work anymore.
when assigned address (on other computer), see modified excel
the original assignment c:\dropbox\myxlstart\mepersonal.xlsb!macroname
it changed c:\users\a-user\appdata ...... consequence macro not found.
how can prevent change, destroys ease of use in setup?
Comments
Post a Comment