Assigned Macro to Excel Button 1

[121854]

I click the button tool on the form toolbar. Drag in the button to the worksheet to create the button. However, I'm not able to assign a macro to the button.

Any suggestions on how to do that?

 

[KenWright]

You're sure it's the Forms toolbar??

What happens when you right click the button and choose Assign macro?

Regards
Ken....................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[121854]

I click on the Control Toolbox. Is that the one that I need to click and drag to the worksheet? Maybe that's my problem.

 

[KenWright]

Nope - Thats the control Toolbox, not the Forms Toolbar - Works differently

View / Toolbars / Forms - Hit it a couple of times and you'll see it toggle on/off - That's the one you want.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[121854]

Karen you're right. I was not in the correct place. I did what you suggested and it Works!.

Thank you.

 

[SkipVought]

Karen???

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[KenWright]

Now I'm worried - What on earth does my profile say that would lead people to believe I'm really a Karen???????

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

mebe 'cuz yer a karen kinda guy?

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[KenWright]

ROTFLMAO

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[AnotherHiggins]

Wait a minute here. Let me get this straight.

Ken, you are not a girl?

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Yea, I always thot that BARBIE wuz a guy and KEN wuz the chik!

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[KenWright]

Hmmmmmmmmmmm............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

Whadaythink....

"shrimp on the barbie"

was supposed to mean?

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[AnotherHiggins]

->I always thot that BARBIE wuz a guy and KEN wuz the chik!

From what I remember on my sister's Barbie dolls, there wasn't much to differentiate between them.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

So YOU did a verification search, TOO! ;-)

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]