Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: lock text box
Hi,
I am trying to insert a text box in an Excel 2007 spreadsheet. I want my users to be able to write text in it, but not change the size/position of the box. Even if I lock the box, then protect the worksheet, I can still change the size/position of the textbox. The only way I have found to stop this, is to uncheck the 'edit objects' option when protecting the worksheet - but this aslo stops any text from being entered in the box. Can anyone advise please? Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: lock text box
It looks as if the old text box control has changed in Excel 2007. Have you
tried the ActiveX Text Box control on the Developer tab, Insert drop down? -- Jim "Vanquish" wrote in message ... | Hi, | I am trying to insert a text box in an Excel 2007 spreadsheet. I want my | users to be able to write text in it, but not change the size/position of the | box. Even if I lock the box, then protect the worksheet, I can still change | the size/position of the textbox. The only way I have found to stop this, is | to uncheck the 'edit objects' option when protecting the worksheet - but this | aslo stops any text from being entered in the box. Can anyone advise please? | Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock text box to cell | Excel Discussion (Misc queries) | |||
Excel 2007 Text Box | Excel Discussion (Misc queries) | |||
how to lock pictures from moving or being deleted in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Lock for viewing | Excel Discussion (Misc queries) | |||
text to voice in EXCEL 2007 | New Users to Excel |