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.

EXCEL 2007.

You could try a Watch Window.

Let us say you want to watch Sheet1 cell E 9.

Formulas / Formula Auditing group / Watch Window / Add Watch / click in
Sheet1 cell E 9 / Add.

Now whenever cell E 9 changes you can see it on the screen in front of you.

If my comments have helped please hit Yes.

Thanks.




"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.

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.