Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Button sizing handles do not appear
I want to assign a new macro to an old button. The button does not have
sizing handles, thus no menu appears - cannot assign a macro. Also, cannot resize the button and cannot delete it. Very strange. Windows XP was recently installed maybe I just do not know what option to switch on/off? Thanks Alex |
#2
|
|||
|
|||
Hi Alex
You have a button from the control toolbox on your sheet I think Right click on a toolbar and mark the control toolbox and press the first button on it to go into design mode This button have a click event and not a assign macro option (see help for more info) -- Regards Ron de Bruin http://www.rondebruin.nl "alex" wrote in message ... I want to assign a new macro to an old button. The button does not have sizing handles, thus no menu appears - cannot assign a macro. Also, cannot resize the button and cannot delete it. Very strange. Windows XP was recently installed maybe I just do not know what option to switch on/off? Thanks Alex |
#3
|
|||
|
|||
Thanks Ron. I used Forms button. It cannot be resized or moved or deleted
after I create it. Alex "Ron de Bruin" wrote: Hi Alex You have a button from the control toolbox on your sheet I think Right click on a toolbar and mark the control toolbox and press the first button on it to go into design mode This button have a click event and not a assign macro option (see help for more info) -- Regards Ron de Bruin http://www.rondebruin.nl "alex" wrote in message ... I want to assign a new macro to an old button. The button does not have sizing handles, thus no menu appears - cannot assign a macro. Also, cannot resize the button and cannot delete it. Very strange. Windows XP was recently installed maybe I just do not know what option to switch on/off? Thanks Alex |
#4
|
|||
|
|||
Maybe your sheet is protected ?
-- Regards Ron de Bruin http://www.rondebruin.nl "Alex" wrote in message ... Thanks Ron. I used Forms button. It cannot be resized or moved or deleted after I create it. Alex "Ron de Bruin" wrote: Hi Alex You have a button from the control toolbox on your sheet I think Right click on a toolbar and mark the control toolbox and press the first button on it to go into design mode This button have a click event and not a assign macro option (see help for more info) -- Regards Ron de Bruin http://www.rondebruin.nl "alex" wrote in message ... I want to assign a new macro to an old button. The button does not have sizing handles, thus no menu appears - cannot assign a macro. Also, cannot resize the button and cannot delete it. Very strange. Windows XP was recently installed maybe I just do not know what option to switch on/off? Thanks Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |