Just a thought.
May be you can create one Button (You already told without using the Button, But just a try) . e.g Object ID : BU01
Actions : OpenURL
then, goto Sheet Properties -> OnActivateSheet -> Actions -> Run Macro ->
Put the Code Like..
You can hide the Button in Layout Tab -> Conditional as '0'
Many thanks for the reply, however its Ajax only so no macros otherwise the macro could have solved the issue.
The only way I can achieve this from a look and feel perspective is if I turn off the tab row and use buttons to navigate between sheets this way I can document chain giving the user the perception of just moving to another tab.
I'm still hoping I can find a resolution for a trigger on sheet open in ajaax