Have you tried placing the textbox above the freeze line at top of sheet?

i.e. place textbox in row 1 then select A2 and ViewFreeze Panes


Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 00:28:05 -0800, Tokyo Alex
wrote:

Dear all,

Is it possible, in Excel 2007, to have a text box 'float' over a sheet so
that it doesn't move when you scroll the sheet? "Don't move or size with
cells" doesn't seem to have this effect.

Reasoning: I have a report that is updated frequently but irregularly, and I
want the date of most recent update to be visible at all times, regardless of
what part of the sheet is being viewed. I'd like to anchor my text box to
the window (or something else that doesn't usually move) rather than to a
location in the document, if you see what I mean.

If at all possible, I'd like to achieve this without using VBA or Macros.

Any ideas would be much appreciated.

Thanks,
Alex.