Macro question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Connie Martin - 30 Jan 2008 20:54 GMT

I'm using Word 2000. I would like to do in Word what I can so easily do in
Excel. In Excel on the Forms toolbar I click on "Button" and a button
appears on the spreadsheet and up pops the "Assign Macro" box. I assign it a
macro that I've already created. Why isn't it that simple in Word? Or am I
missing something? Can someone tell me how to insert a button in a Word file
and assign it a macro that I've created, that when you click the button the
macro will run, and that will be able to whoever I e-mail the document to?
Thank you. Connie

Reply to this Message

Jay Freedman - 30 Jan 2008 22:23 GMT

> I'm using Word 2000. I would like to do in Word what I can so easily
> do in Excel. In Excel on the Forms toolbar I click on "Button" and a
[quoted text clipped - 4 lines]
> created, that when you click the button the macro will run, and that
> will be able to whoever I e-mail the document to? Thank you. Connie

See http://www.word.mvps.org/FAQs/MacrosVBA/AssignMacroToButton.htm.

You should be aware that if you store a macro in a document and mail it to
another user, opening that document will display a message box asking
whether to disable or enable macros. As the originator of the document, you
have no control over what the recipient does with that message box.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Reply to this Message

Connie Martin - 31 Jan 2008 16:24 GMT

Thank you, Jay. That was simple enough. Not as nice as Excel works but
okay. I was not able to customize the borders because as soon as I choose a
light line for the top border it puts a light line on all four sides.
Three-dimentional will not work either. Don't know why, but I guess I'll
have to take it the way it is. It doesn't look like a button, but the words
are there to double-click. It's a mystery to me why it couldn't be done as
simple and nice as Excel does it. It's simple to create and it automatically
looks like a button. Connie

> > I'm using Word 2000. I would like to do in Word what I can so easily
> > do in Excel. In Excel on the Forms toolbar I click on "Button" and a
[quoted text clipped - 11 lines]
> whether to disable or enable macros. As the originator of the document, you
> have no control over what the recipient does with that message box.

Reply to this Message