Unprotecting a sheet once a text box is selected

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
1,581
I have both a text box and an active x text box at the bottom of my spreadsheet. I am trying to get one of them working and then I will delete the other one. I want to protect my sheet but also be able to write in a notes box at the bottom. The box needs to be able to have multiple lines.

If the sheet is not protected, the regular text box works exactly as wanted by expanding as you put more text in. If you protect it, the regular textbox does not expand as you hit enter.

An active x text box allows you to press enter for a new line but the text just scrolls up in the box so you can see the new line but it won't increase in size.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,080
Office Version
2013
Platform
Windows
@Logit What do you mean by paste ?
You already have an existing TextBox?
If so, right click on any border of the textbox>>Copy>>select the new location>>Paste
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,484
I'm using Excel 2007. When the Insert Popup appears, the Regular Textbox is greyed out. It cannot be selected.

The only textbox that is available to paste onto a sheet in the ActiveX textbox.

Has this feature changed with the most recent versions of Excel ?
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,484
Thanks for the pic. I wasn't clear on my request for a pic. Can you post a pic of the INSERT popup that you use to select a REGULAR TEXTBOX ?
My version of Excel has the REGULAR TEXTBOX greyed out.
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,058
Office Version
365, 2010
Platform
Windows
That is FABULOUS !!

I just learned something new today. Thank you.
You are welcome - thanks for the reply.
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,484
I understand that Excel 365 permits selecting a Regular Textbox to paste onto a worksheet. Is that available in other versions of Excel
that were released AFTER 2007 ?
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,058
Office Version
365, 2010
Platform
Windows
Forget the Developer tab. Go to the Insert Tab and look for Textbox in the Text tools section. Click the icon, click the sheet and drag to size you want on the sheet. This has been around at least since Excel 2007 and maybe longer.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,854
Messages
5,507,717
Members
408,646
Latest member
Swilliams4

This Week's Hot Topics

Top