Moving shapes

[gummi]

I've been wondering if it would be possible to move shapes on the screen, like having them on upper right corner all the time as you scroll down on the workbook.

I've few macro buttons, 'search', 'print' and such and I'd like them to stay on the screen all the time. I've been trying to search for a way to move them but so far havent found anything.

[shg]

Why would you want to do that? Whatever spatial relationship the shapes had would be lost.

[gummi]

Well... I'd like to have kind of a toolbar which stays in upper right corner.

I guess there's a way of making a real toolbar, but I've done so far everything with shapes ( with assigned macros) so I'd like to stay that way...

I was thinking of assigning two variables, button_x, button_y putting it like ... (window_size -100) if possible, and then all of my buttons would be relative to that.

There's quite big database to scroll through and buttons jump between sheets, and it's annoying the user has to scroll always up to the buttons to change the sheet. (User should not change sheet using the sheet buttons down at the 'taskbar' as I've macroes in the bevels I made)

Thanks for any answers.

If some of my scribblings need clarifying, just write. It's 7:30 in the morning and been working all night :P Should finish my project by the end of month.

[shg]

You could just freeze panes at a certain row, and put the shapes above that row.

[gummi]

Thanks Didn't think of that :P

BUT if I would like to move the shapes relative to the window size and x and y locs, would you know how to do it?

[gummi]

Ok. Thanks again. I've settled with the freeze panes. Is nice enough.