Enable Multiline option on Sheet Textboxes when sheet is protected for userinterfaceonly=true

[bradyboyy88]

As the title reads. It seems you cannot press enter to move to a new line for textbox.... atleast I have not been able to figure this out. So is there a way to enable this so the user can hit enter and go to a new line or do they really have to hit ctrl shift enter which would be cumbersome to explain to every user..

 

[Domenic]

You must be referring to an ActiveX textbox, correct? If so, in addition to setting the MultiLine property to True, you can set the EnterKeyBehaviour property to True.

 

[bradyboyy88]

You must be referring to an ActiveX textbox, correct? If so, in addition to setting the MultiLine property to True, you can set the EnterKeyBehaviour property to True.

No I am using the shape textboxes and not the activex ones. Any ideas?

 

[Domenic]

When you set UserInterfaceOnly to True, set DrawingObjects to False. For example...

Worksheets("Sheet1").Protect, DrawingObjects:=False, UserInterfaceOnly:=True

To set it manually...

Ribbon >> Review >> Protect sheet >> Edit objects >> click OK

 

[bradyboyy88]

ADVERTISEMENT

When you set UserInterfaceOnly to True, set DrawingObjects to False. For example...

Worksheets("Sheet1").Protect, DrawingObjects:=False, UserInterfaceOnly:=True

To set it manually...

Ribbon >> Review >> Protect sheet >> Edit objects >> click OK

I guess I should have mentioned that I do not want shapes to be movable which this option allows for.

 

[Domenic]

In that case, try the following...

Right-click the shape/textbox > Format Shape > Properties > and uncheck "Lock text" > Close

 

[bradyboyy88]

ADVERTISEMENT

In that case, try the following...

Right-click the shape/textbox > Format Shape > Properties > and uncheck "Lock text" > Close

So the shape is created via addtextbox through part of the macro and I have set the property of locktext to false via vba. So of the combinations I have tried it seems that when setting locked cells to be selectable is the only combination I have found where you can still use the typical textbox functions like enter, tab, arrow keys, etc. Any other ideas then?

 

[Domenic]

In order to set the property for LockedText, you'll need to access the ControlFormat object. For example, let's say that tb represents a Shape object, you'll need to do the following...

[I]tb[/I].ControlFormat.LockedText = False

Have you done so?

 

[bradyboyy88]

In order to set the property for LockedText, you'll need to access the ControlFormat object. For example, let's say that tb represents a Shape object, you'll need to do the following...

[I]tb[/I].ControlFormat.LockedText = False

Have you done so?

Yes I have done and it allows me to edit the text but I am still left with the problem of not being able to press enter if the sheet is protected for user interface and the drawingobjects:=false allows the user to move the textbox which I did not want.

 

[Domenic]

Set DrawingObjects to True. Or, since the default value is True, you can omit the argument altogether.