Hey,

I'm trying to lock at Text Box in place but I can't seem to figure it out. I'm trying to create an interactive sheet that others can add text to he boxes but not be able to move the boxes, anybody have any suggestions?

Thanks

10/10/2012 9:33:14 AM

right click on tbox border

click size and properties

click properties

select "don't move or size..."

select print object and locked; uncheck lock text.

protect sheet; don't allow object editing. don't use password.



[Edited on October 10, 2012 at 9:47 AM. Reason : right path this time]

10/10/2012 9:39:12 AM

dude lurked for 4 years and decided that THIS was going to be his first poast

10/10/2012 12:07:37 PM

haha, I have to start somewhere...

10/10/2012 1:04:02 PM

I'm curious now what the box is for

10/10/2012 1:15:16 PM

welcome to TWW

10/10/2012 1:15:44 PM

^

10/10/2012 1:25:58 PM

Thanks for the welcome!

It's actually for work, haha. I'm trying to create a template in Excel for my company to be able to send out and have people fill in the blanks without messing everything up.

10/11/2012 8:46:23 AM

You can lock cells and ranges in excel and still leave others editable too if that helps

10/11/2012 9:04:15 AM

just make a PDF form from it

10/11/2012 9:20:56 AM

Does anyone know any freeware that I could use to make a PDF form?

10/22/2012 2:29:56 PM

welcome to TWW

10/22/2012 3:15:19 PM

http://www.pdfescape.com/

11/15/2012 11:38:15 PM