ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Button (https://www.excelbanter.com/setting-up-configuration-excel/84418-button.html)

nobbyknownowt

Button
 
Help
Why cannot i put a button on the sheet I want to?

I can do it on a blank sheet or even other sheets in the same workbook.
As far as I know there are no differences with the two sheets.
The forms toolbar cursor changes to a small thin cross on both sheets but will not generate a box on the sheet I want to put it on.
Is there perhaps a setting I need to adjust??
cheers
nobby

PS its the same with the crawing toolbar, cannot input text box or callouts etc?????
PPS also cannot edit the size of a comment box.

Must be a setting somewhere I clicked.

Gord Dibben

Button
 
The sheet is protected under ToolsProtection?


Gord Dibben MS Excel MVP

On Fri, 21 Apr 2006 14:21:56 +0100, nobbyknownowt
wrote:


Help
Why cannot i put a button on the sheet I want to?

I can do it on a blank sheet or even other sheets in the same
workbook.
As far as I know there are no differences with the two sheets.
The forms toolbar cursor changes to a small thin cross on both sheets
but will not generate a box on the sheet I want to put it on.
Is there perhaps a setting I need to adjust??
cheers
nobby

PS its the same with the crawing toolbar, cannot input text box or
callouts etc?????
PPS also cannot edit the size of a comment box.

Must be a setting somewhere I clicked.



nobbyknownowt

Nope,
first thing i tried.
thanks anway


All times are GMT +1. The time now is 10:24 PM.

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