Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |