alternative to TextBox1.Activate

Hi Forum

Could you give a hand with the following:

1. Worksheet with several TextBoxes from Controls Toolbar

2. In order to jump between the TextBoxes used

Please Login or Register  to view this content.

3. Worsheet runs well protected but when Shared generates a error "Activate method of OLEObject failed"

4. Debugging the code, found the activate from the TextBox is where the error occurs.
5 Turn on the "Trust Access to Visual basic Project" but the bug remains.

6. Is there a way to "jump" to the next TextBox using a method allowed in a shared environment?

All ideas welcome and appreciated.

Thanks

Jose Luis

Trying to found a solution I research that changing the textboxes to simple cells I can use
Application.Goto Reference:=Sheets(1).Range("NameCell")

Nevertheless, I would like to find a way to keep the Textbox Look and posibility of using their properties.

All ideas welcome

Thanks

Joe Louis

Originally Posted by jose luis

Hi Forum

Could you give a hand with the following:

1. Worksheet with several TextBoxes from Controls Toolbar

2. In order to jump between the TextBoxes used

Please Login or Register  to view this content.

3. Worsheet runs well protected but when Shared generates a error "Activate method of OLEObject failed"

4. Debugging the code, found the activate from the TextBox is where the error occurs.
5 Turn on the "Trust Access to Visual basic Project" but the bug remains.

6. Is there a way to "jump" to the next TextBox using a method allowed in a shared environment?

All ideas welcome and appreciated.

Thanks

Jose Luis