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

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

angular - password and confirm password field validation angular2 reactive forms -

php - Permission denied. Laravel linux server -