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
Post a Comment