![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com