ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Button sizing handles do not appear (https://www.excelbanter.com/excel-worksheet-functions/28032-button-sizing-handles-do-not-appear.html)

alex

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

Ron de Bruin

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




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





Ron de Bruin

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