Cant assign macro to command button

G

GFM

Hello people

Wonder if u can help me, it shld b a really str8fwd pb

I've created a simple macro (for inserting columns & copying across data),
and wanted to assign it to a command button.
Usually, I'd right-click that button, choose 'assign macro' and select my
macro...

Only thing is, there's not that option.

So, is it a case of selecting or switching an option on/off in the tools>
options menu?
I did try the Tools> Macros> Security, to enable Medium security, but it
didnt help.

I'm using Win2k Pro, and Excel 2k Sp3

Cheers!

Gui.
 
P

papou

Hi
It seems like you have created a command button from the controls Tools box.
In which case the option you're after is "View Code"
HTH
Cordially
Pascal
 
G

GFM

thanks, but after clicking 'view code', i get into the visual basic editor
window... which is not what i want, not really knowing how to program in VB
(ie, clueless if asked to program) :)
no, what i usually do is create a macro, then bring up a command button,
right-click it and choose 'assign macro'... now, i dont have that option
when i right-click... mmm, it's annoying
 
G

GFM

damm! you're right
fantastic. so it's not the command button in toolbox that i should choose
simply use it from the 'forms' toolbar
cheers 4 yr help
 

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

Similar Threads

Assign a Macro to a Command Button 1
Assign Macro to command button Problem 1
Macro Command Button 1
Assign Macros to Buttons from Right-Click Menu 2
Problem Assigning Macro to Button 3
Assign Macro to Command button by right click 3
attaching a macro to a control button in the Quick Access Toolbar 1
Create A Button and Assign A Macro To It 2

Top