Word VBA: Make macro easy to run -


i've made form-letter document macro performs mail merge. don't want user have run menus, , want portable. if there's way button appear on each user's ribbon or quick command menu, i'm not familiar it.

so put button in document itself. unfortunately, every form-letter created has same button in it. suppose write code delete every one, think slow.

is there way assign shortcut key existing macro, , have reside in document?

i had implement pretty similar referring 10 staff. solution (by no means portable desired) export macros , forms normal template other users, coupled ribbon customization , worked well. unfortunately, when change needed, had trudge on everyone's machine individually.

i suggest stick solution of deleting button after merge complete. here's code that:

sub deletecommandbutton()     each o in activedocument.inlineshapes         if o.oleformat.object.name = "commandbutton1"             o.delete         end if     next  end sub 

good luck, helps.


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -