Screen Movement With Macros

[beatnik]

I've made quite a few programs I use in excel and have wondered about this for awhile.

When you run a macro that selects cells and objects off screen or on other sheets, the screen moves to those places. Is there anyway to lock the sheet so this doesn't happen and things look a bit more professional ?

[shg]

The general answer is that you rarely need to select anything to operate with it, so don't.

[JK1234]

When I use a macro I do this:

at the beginning then do this at the end of the macro

Is this what you were looking to do??

[royUK]

I agree with SHg, the main cause of socalled screen flickering is Selectin and it is generally unnecessary.

[beatnik]

Okay, that makes since. Just how do you write code that doesn't select. You see, I learned what little I know by recording macros and looking at them, kind of a hack at this, but I get it done.

Here is an example, how would you do this without actually selecting sheets and cells etc.

Please Login or Register  to view this content.

[beatnik]

When I use a macro I do this:

at the beginning then do this at the end of the macro

Is this what you were looking to do??

That does exactly what I was wanting.

Thanks!

But, is there something else I should be doing as far as my last posted code?

[broro183]

hi,

Here's a slightly modified version of your code which shows how some of the sheet selection & can be removed & also how you can use With statements when multiple things are being done to a single object...

Please Login or Register  to view this content.

hth
Rob

[royUK]

I can't test this without an example but something like this

Please Login or Register  to view this content.

[broro183]

on second thoughts this may be quicker for getting the new sheet name (replace my previous "for i = 10 to 2" with the below...

Please Login or Register  to view this content.

hth
Rob

[beatnik]

Now I need to sit down and see exactly what you've done.

I really appreciate the help,
Michael