Solved: Real quick, regarding User Made Objects...

[thomaspatton]

Maybe I'm just missing a checkbox option somewhere so feel free to make me feel dumb, but how do you keep usermade boxes and the like from moving with the page?

In other words, I trying to make a box always pop up in the center of the screen when the code runs, But if I'm down at the bottom of a page and it's called, it pops up right where I drew it. Very handy to keep from misplacing my boxes, but very inconvenient for my process.

Help my Obie Wan Kenobi... or even XLD if ya ain't too busy.

[Bob Phillips]

This seems the opposite bhaviour to what most others get. For me a userform always opens up in the middle of the window, unless I explicitly move it.

Are you saying that your userforms opens where the activecell is?

[thomaspatton]

Nope. I mean just user objects like a drawn square or circle. For example, If I draw it at the top of the page and hide it, I can scroll down 7 billion rows and call it visible, but it's still at row 1, not at the top of the viewing page.

Are you saying I should use a UserForm instead?

[thomaspatton]

Solution :

Use UserForms instead of lone objects.

>.o