VBA (Excel 2007) Rotating Globe View

Sounds like you need some type of timer function to make the image rotate. You can use the not() function to change the state of a boolean to track whether to rotate or not to when the click event occurs. rotate = not(rotate)

your intention - sounds to me as beyound the scope for excel - though not impossible
you could attempt to create programmatically (MSO VBA ! using Windows API !) ::

a insertable bitmap object that you may or may not be able to paint with ::

a snapshot of OpenGallery or Active-X "3D scene" <- you also have to create it separately using windows API-s

so i guess its possible but - due the limitations of office/excel it may be too slow/junky for an end user to use it as a real time thingy - although - it might and work

...

i gess it'd be more realistic to do your thing in JAVA or other web app - or write a separate program for such (you wont have to do the guessing job how to embbed such program in MSO environment)

ups! it's DirectX i gues - however the - "manipulating "directx scene" object "from within" the mso excel" - didn't reveal any results in web search ???

maybe this could be some starting point