AboutAidan Heritage Expertise I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for
all versions from 2 onwards
Experience My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.
Education/Credentials I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!
Question QUESTION: I got many textbox in my worksheet and i need to entry some text in it. To facilitates the process, i need to un-protect my sheet to do it. By unprotect the sheet, i got the risk to have some cells modified .
I need to un-protect only my textbox or have a system to protect my sheet automatically when textbox(s) is no in use.
Excuse my English, I'm more fluent in French.
ANSWER: I'm slightly puzzled in that any textboxes I would enter on the sheet WOULD be open to data entry without unprotecting the sheet - which version of Excel are you using, and what form of textboxes are you referring to? If it helps to mail me a sample file you can get me at aidan.heritage@virgin.net
My french isn't what it should be considering my mother lives in the Alliers region of France!
---------- FOLLOW-UP ----------
QUESTION: Hello Aidan & thanks for the reply
I'm from Quebec, Canada, One of the only french speaking region in North America.
I use Excel 2007. The problem with Textbox in a protected mode is that yes you could enter some data. But as soon as you press the enter key, i get out of the box. And i cant use the canceled key, as using it erase and remove the complete textbox.
I got 12 textbox to complete with text and data. To succeed in used it them, i need to unprotected my worksheet. And...as expected i scramble some formula by not protecting it again
Martin
Answer I suspected you might be Canadian as the large majority of questions come from USA/Canada - I'm not 100% sure what you mean by textboxes, as there ARE textboxes that can be included from the developer ribbon, but these would allow inputs. I'm WONDERING if you simply mean cells on the worksheet? If so, right click the cells, choose the FORMAT option, click the protection tab and mark as NOT locked (i.e. remove the check mark). Once the sheet is protected these areas WILL allow inputs, but other areas will not.
If not clear, please email me (aidan.heritage@virgin.net) with a sample file and I can try and help further.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
