Enabling Edit>Paste when a textbox on a protected form has the focus.

**ShortyTheDog** · 01-24-2007, 10:22 AM

I have a protected spreadsheet that contains textboxes.

Data that is selected and "copied" from another document needs to be pasted into the textbox; however "Paste" is disabled under the Edit menu.

Ctl+V works, but I am dealing with a number of people for which that option is politically a non-starter.

Is there anyway I can enable the Edit>Paste on the menu?

Thanks,
Al

**ShortyTheDog** · 01-24-2007, 05:16 PM

Additionally, I am not even able to select any of the items displayed for pasting when I select "Office ClipBoard" from the Edit menu.

Thanks,
Al

**ShortyTheDog** · 01-26-2007, 05:03 PM

After much searching I found that there is a problem with Office 2003 version.

ActiveX controls don't always act as they are supposed to.

This link is to the Microsoft Article.

http://support.microsoft.com/kb/817112/

Al

**MSP77079** · 01-26-2007, 08:07 PM

The link you found has nothing to do with what you are describing. The link is referring to non-standard ActiveX controls.

The problem you are seeing is that a text box embedded on a worksheet is like a "drawing object".

I would suggest giving the users a button they can click which will take text from the clipboard and paste it to the text box.

http://www.cpearson.com/excel/clipboar.htm

**ShortyTheDog** · 01-30-2007, 10:00 AM

I guess I expected the textbox in Excel 2003 to act the same as an Access Textbox where the problem doesn't exist.

They'll have to live with Ctl+V... there are multiple textboxes on the spreadsheet which prints out as a header to a report and there is no room for multiple buttons....

Your help was much appreciated.

Al