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

"Meme" wrote in message
...
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

-----Original Message-----
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

"Meme" wrote in
message
...
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


.