vba - Excel: Object Text Box can't do Carriage Returns in Protected vs. Unprotected Sheet states (w/ Text Unlocked)...why? -

-

First and foremost, due to my hard work, I answered a ton about the Extix Text Box, but there is really nothing about the object text box. For my project, I can not use any ActiveX.

OK, so when a sheet is unsafe, one object text box (insert> images) is very much the way I want it works: most importantly, when it happens I can hit the Enter key and get a carriage return. Then, I go into the size properties, and uncheck the lock text, and I protect the sheet.

Once the sheet is safe, even then, the ability to return the car (type the type, and go down one line) goes away. Shift + Enter and also not Alt + Enter.

Is this functionality not available? Are there any solutions? Why does Excel hate me? Here are some of my thoughts:

  • Unsecured sheets, when not clicked / activated (this did not understand the syntax in VBA for this.) "If there is a difference. .. "
  • Insert Word Doc Object (do not like it because one-click formula bar enters editing, and I can not find the font to stay)
  • Just use a merged cell and give the user a new line Double-click to enter Alt + Enter and use.

The winner is now using the merged cell for now, but I may be able to see if ActiveX will work on our network. I really want the kiss theory to be here if it is possible for the end user ... I do not have coding to do this work in backend, though.

Thank you for your thoughts!

Edit: Here are some images to help ...

Here's my functionality when my sheet is protected: unsecured text box size

Next, this is an ActiveX text box with its property window displayed ( Developer> Design mode> Properties) Properties that make it somewhat usable when the Sheet is preserved, are considered in red and the key is Treatment record. But again, I do not want to use ActiveX ... In addition, the user can not change the font color from the line.

ActiveX text box

Finally, let me find this interesting Detected: There is another text box under the form control which is grayed out. From search, it seems that the drawing object of the text box was moved in favor of the version ... or maybe it's the same? One of the left paintings objects, gray in the middle is form control, and the right is Active X.

Enter the image details here

In the amount, I see I want the sheet box size of the unsafe sheet is a way to get the functionality of the box when the sheet is preserved. / P>

Assuming that you are working with a text box size , Inserted by ribbon, here:

Enter image details here

< P> Then you can use it in the safe method in the optional parameters: 

  sheet 1. Protected Drawing Object: = Incorrect

This will allow the user to edit the text boxes on the worksheet, but the sheet will remain safe for themselves.

If you are using form control (included with the developer / design ribbon) you can set the . Multiline of the property's shape by OLEFormat.Object : 

  sub-test () dim shape as a shape shaped as X Get a handle on the size set TB = ActiveSheet.Shapes (2) 'OLEFormat.Object: tb.OLEFormat.Object.Object.MultiLine = True End Sub

Use, even on a secure worksheet, allows the user to enter Shift + to insert the carriage return. :

Enter image details here


Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

java - Messages from .properties file do not display UTF-8 characters -

-
Image
In the form of a title, I can only add that if I enter the html file manually, then it Okay. View Rolver: & lt; Bean id = "templorellolver" class = "org.thymeleaf.templateresolver.ServletContextTemplateResolver" & gt; & Lt; Property name = "prefix" value = "/ web-nf / templates" /> & Lt; Property name = "suffix" value = ". Html" /> & Lt; Property Name = "Template Mode" Value = "HTML5" /> & Lt; Asset name = "cacheable" value = "wrong" /> & Lt; Property Name = "characterEncoding" value = "UTF-8" /> & Lt; / Bean & gt; & Lt; Bean id = "Template Engine" class = "org.thymeleaf.spring3.SpringTemplateEngine" & gt; & Lt; Property Name = "Temploreolar" ref = "Templarolver" /> & Lt; / Bean & gt; & Lt; Bean square = "org.thymeleaf.spring3.view.Thymel...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more