VBA to make textbox field editable on protected sheet

[bradyboyy88]

Hi,

I have a excel worksheet with a textbox shape and when the worksheet is protected the user cannot enter anything into the textbox. I want the users to be able to enter into the textbox but not move them or edit any aspects of them. Is this possible to do via the shape or textbox object or do I need to make this happen in my protect sheet function?

Any help would be appreciated.

 

[JLGWhiz]

Hi,

I have a excel worksheet with a textbox shape and when the worksheet is protected the user cannot enter anything into the textbox. I want the users to be able to enter into the textbox but not move them or edit any aspects of them. Is this possible to do via the shape or textbox object or do I need to make this happen in my protect sheet function?

Any help would be appreciated.

when you protect the sheet, uncheck the 'Edit Objects' box in the pop up 'Protect Sheet' dialog box. You have to scroll down to see that item in the options.

 

[bradyboyy88]

when you protect the sheet, uncheck the 'Edit Objects' box in the pop up 'Protect Sheet' dialog box. You have to scroll down to see that item in the options.

When you hit protect sheet edit objects is unchecked by default. So I still cannot seem to enter anything into the textbox when its unchecked. Any ideas?

 

[JLGWhiz]

When you hit protect sheet edit objects is unchecked by default. So I still cannot seem to enter anything into the textbox when its unchecked. Any ideas?

did you try checking the edit objects box? I haven't used sheet protection in so long I forgot how the ritual goes, but seems like you had to unprotect and then re-protect to change the exception options. Might be a good idea to search for a tutorial on the web for protecting worksheets.

 

[bradyboyy88]

did you try checking the edit objects box? I haven't used sheet protection in so long I forgot how the ritual goes, but seems like you had to unprotect and then re-protect to change the exception options. Might be a good idea to search for a tutorial on the web for protecting worksheets.

Using active x textboxes it works but im trying to stay away from them. Theres gotta be a way !

 

[bradyboyy88]

I am an idiot. The properties was set to locked text...

 

[bradyboyy88]

Is there a vba method to change a textbox shape to lockedtext = false?

 

[JLGWhiz]

Is there a vba method to change a textbox shape to lockedtext = false?

Probably

Sheets("Sheet1").Textbox1.Locked = False