2
votes

I have a vba macro that runs from a ribbon button and opens a template. Modifications to the template are made using other buttons alongside the first. However, when the template opens from the "Template" tab as a new document, the "Home" tab is reselected. Is there code I can add to the end of the macro which would automatically switch it to the "Template" tab?

1

1 Answers

0
votes

You can manipulate with keyboard combination Alt + Home + (2x) Esc

SendKeys "%(H)", False
SendKeys "{esc}", True
SendKeys "{esc}", True