If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Text Box Controls
Is there any way to allow a user of a spreadsheet to cut and paste text in and out of an Excel Text Box? Is there a setting that I am missing? Also, the workbook is protected from altering specific cells.
|
#2
|
|||
|
|||
Excel Text Box Controls
Ron, when protecting the workbook, deselect the Objects check box under
Protect worksheet for (Tools Protection Protect Sheet). That will allow users to cut/copy and paste into and out of text boxes. (I'm using Excel 2000, btw. YMMV.) -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "Ron Green" wrote in message ... Is there any way to allow a user of a spreadsheet to cut and paste text in and out of an Excel Text Box? Is there a setting that I am missing? Also, the workbook is protected from altering specific cells. |
#3
|
|||
|
|||
Excel Text Box Controls
Sorry, but I need a clearer explanation.
I've tried every combination of checkign and uncheckign the object box under Protect Sheet and am still unable to copy text out of and paste text into an Excel text box. Please help! |
#4
|
|||
|
|||
Excel Text Box Controls
What do you mean by clearer explanation? What version of Excel are you
using? You got an answer how to do it in Excel 2000, in Excel 2002 and 2003 you select edit objects when you protect the sheet. Also not that you have to use Ctrl + C since editcopy will be grayed out -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "Ron Green" wrote in message ... Sorry, but I need a clearer explanation. I've tried every combination of checkign and uncheckign the object box under Protect Sheet and am still unable to copy text out of and paste text into an Excel text box. Please help! |
#5
|
|||
|
|||
Excel Text Box Controls
Ah, I think I've got it. I have been inserting text boxes from the "Control Toolbox" toolbar, but just discovered that the text box available on the "Drawing" toolbar can do what you are suggesting.
Next question: Using a "Drawing" toolbar text box, can I allow the user to access spell check when the sheet is protected? |
Thread Tools | |
Display Modes | |
|
|