Static Object within Sheet??

[tompee29]

Hi,

Does anyone know if it is possible to have a static object (i.e. a text box/shape/picture etc) that stays in the same place in vision on the screen whilst you scroll a spreadsheet up and down??

Many thanks,
Tom.

[shg]

You could put it above the FreezePanes line, or show it in a separate window, or use a userform.

[tompee29]

no room for freezpane....... what is a user form?

can you overlap a second window with in a sheet?

FYI i am looking to set up a set of macro buttons that stay in the top right hand corner of the sheet.... the sheet is 1000+ rows so want the macro buttons to just hang in the top right as the sheet goes up and down!?

thanks

[shg]

what is a user form?

http://www.contextures.com/xlUserForm01.html

http://www.fontstuff.com/ebooks/free/fsuserforms.pdf