Command Button

M

Meme

Hi all,

I created a command button in my spreadsheet , now my
question is how I can assign my macro to this button .

Any inputs are appreciate.

Meme
 
J

JulieD

Hi meme

right mouse click on it and choose assign macro - if it is greyed out, click
on the border of the command button and try again

cheers
JulieD
 
M

Meme

Hi JulieD
I tried , there is no "assing macro " option at all, the
option it shows is
cut
copy
paste
property
grouping
order
format control

Please help!
Meme
 
J

JulieD

Hi meme

how did you create the command button?
if i use the one off the forms toolbar i get cut / copy / paste / edit text
/ grouping / order /assign macro / format control
what version of excel are you using?
what is your security settings set to (tools / macros / security)?

Cheers
julieD
 
A

Always Learning

Hi Meme,

Dont select the button first. Hover your mouse over the button and right
click. This will select the button and bring up the popup menu all in one.
Assign macro will be listed.

All the best,

Steve Wilson.
 
M

Meme

Hi JulieD

Here is how I created my command button:
From the toolbar memo, I clike the command button, then
on the spreadsheet, the curser turned to a cross and I
draw a command button.
My excel version is MS 2000, and the security setting is
medium.

Thanks so much for your help
Meme
 
G

Gord Dibben

Meme

You have created the button from the Control Toolbox.

You should have a "View Code" option when you right-click.

Paste your macro code in there...

OR create a button from the Forms Toolbar, which will allow the right-click
"assign macro".

Check out this google search result for more info.

http://snipurl.com/6v6v

Gord Dibben Excel MVP
 
M

Meme

Thank you so much!!!!!!!!!!
Have a great weekend
-----Original Message-----
Meme

You have created the button from the Control Toolbox.

You should have a "View Code" option when you right- click.

Paste your macro code in there...

OR create a button from the Forms Toolbar, which will allow the right-click
"assign macro".

Check out this google search result for more info.

http://snipurl.com/6v6v

Gord Dibben Excel MVP



.
Click to expand...
 
Top