ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you stop editing the text in a created button (https://www.excelbanter.com/excel-discussion-misc-queries/56149-how-do-you-stop-editing-text-created-button.html)

kara

how do you stop editing the text in a created button
 
i'm in the process of setting up a spreadsheet, which happens to include
macros!

now the only problem i have is everytime i press the relevant button i've
created and assigned a macro to it goes straight in to the editing text mode!
is there any way of stopping that!


Gord Dibben

how do you stop editing the text in a created button
 
Sounds like a command button from the Control Toolbox.

Open the Control Toolbox Toolbar and click on the design button to "exit
design mode".

This would be the top left button on the toolbar.


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 08:18:13 -0800, "kara"
wrote:

i'm in the process of setting up a spreadsheet, which happens to include
macros!

now the only problem i have is everytime i press the relevant button i've
created and assigned a macro to it goes straight in to the editing text mode!
is there any way of stopping that!




All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com