Shape to always be in view?

[wrightyrx7]

Hi all,

Is it possible to have a 'shape' that i have inserted to always be in the Top LEFT corner regardless in a worksheet?

I have the TOP ROW frozen at the minute and the "Shape" always shows when moving down the rows. The problem is that you can not longer see it when moving across the columns.

Thanks in advance.

Cross-posted - http://www.mrexcel.com/forum/excel-q...ml#post3689404

[cytop]

There is no event that is raised when a worksheet is scrolled.

There are 2 alternatives:

• Use a timer to position the shape every so often (Yeuch!)
• Subclass Excel (Double or treble yeuch, in bold, caps italicised and bright red)

The timer is a simple approach which I'll leave to you. Subclassing Excel is 'advanced programming' and has the rather dubious honour of having the potential to crash Excel (immediately, and without warning) or cause a BSOD if you dare even go into the VBA dev environment while the code is running - so that's not something to consider as a quick hack. It's not a problem with the code, but rather the code is intercepting Windows messages and acting on them. Windows does not take kindly to having it's messages held up while you poke around in the code.

If you really want to explore this option, have a read... However, I'd seriously suggest you use it as an 'educational' exercise and only dare to roll it out once you're totally happy you understand what's happening, what it does and how it works. Users tend to get a little upset if Excel disappears taking the last 4 hours work in 5 workbooks with it.

[wrightyrx7]

Hi Cytop,

I think i will leave this then. The person using the Workbook will just have to scroll back to Column "A" the last thing i need to to chance it crashing and us losing data.

Thank you very much for this information.

[Andy Pope]

freeze both the top row and first column