Active X Text box needs to be able to have the user enter text when sheet is protected.
All combinations did not allow for text to be entered into Activex text box
Any Ideas what I missed?
Settings
Protect Sheet-Edit objects checked (did not work when unchecked either)
Linked Cell, on same sheet-Unlocked (When sheet is protected text can be entered into the linked cell)
Properties>Locked = False (did not work)
Properties>Locked= True (Did not work)
Format Control Protection Box checked or unchecked did not allow text to be entered.
All combinations did not allow for text to be entered into Activex text box
Any Ideas what I missed?
Settings
Protect Sheet-Edit objects checked (did not work when unchecked either)
Linked Cell, on same sheet-Unlocked (When sheet is protected text can be entered into the linked cell)
Properties>Locked = False (did not work)
Properties>Locked= True (Did not work)
Format Control Protection Box checked or unchecked did not allow text to be entered.