Shortcut in userform

F

Flip

Hi NG,
Is it possible to somehow add a shortcut to a userform? I would like to give
users a way to quickly edit a supporting worddoc (which is at their own PC
or in the LAN) for the document they are actually working at.

Flip
 
F

Flip

Well, I can answer myself partially:
Write some code to open the supporting document over the first one. Don't
forget to first hide the userform. Put all of this behind a command button.
This works ok unless I press the new button rightaway.

The userform is called in an autonew macro (choose and put an adress from
the other doc in the main doc). Pressing the command button while still in
the Autonew
macro is not good because the main doc was not open yet. So after hiding the
userform both docs open, mixing text from doc 1 into 2. Great :-/

For now I removed the command button from the userform en put the code in a
macro that can be called from a toolbar in the main document. There is
another button to call the userform again so users can still switch easily.

Thanks anyway,
Flip
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top