I've built a tool for folks at work that they can use to enter some data via Excel and have it generate a deck of powerpoint slides. Each slide includes a bunch of bullet statements. I've taken the approach of putting a textbox on the Excel sheet that fits the format of the slide. So they can type whatever they want and format it however they want within the textbox and be sure that it will fit on the slide. But in anticipation of the user who decides they can fit one more bullet in if they just enlarge the text box I'd like to lock down the dimensions of the box. I believe I can do that by protecting the sheet, but then they can't put their text inside it. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Lock the size of an Excel text box, not the contents
Similar threads
- Question
- Solved
