Ratman needs help / TextBox focus

[ratman]

How to set focus to an embedded text box control on a shared worksheet, NOT part of a UserForm collection of controls Thank you,
Dave Rattigan

 

[kevinclark]

Will you know the name of the TextBox control ?
If so then maybe try

Sheets("NameOfSheet&quot.DrawingObjects("NameOfTextBox&quot.Activate

 

[ratman]

Thanks Kevin.....but that only works on a unshared (ExclusiveAccess) workbook; mine is shared (MultiUserEditing).

As a go around I tested it for sharing then if shared I unshared it, activated the TextBox then saved as shared. Thank you,
Dave Rattigan

 

[kevinclark]

Hi Dave

Glad to hear you found a work around. I havn't worked with shared worksheets too much so I will keep that one in mind as well.

Thanks
Kevin