Macros with hidden sheets

[Perini 9]

Hi there,

I have 2 doubts by excel macros. I have created a macro which uses information from other sheets in the same file. When I hide those sheets (which I need to) the macro doesn't work... Is it possible to keep it running with hidden sheets?

The other doubt is also link with the same problem. When I have a macro that uses information from other sheets in the same file, while it is running it quickly jumps to the other sheets. Can I run the macro but remain in the same sheet where the macro is, without any "jumps" from sheet to sheet?

Many Thanks

Regards to you all

Perini

[anilsolipuram]

Can I run the macro but remain in the same sheet where the macro is, without any "jumps" from sheet to sheet?
Yes you can.


When I hide those sheets (which I need to) the macro doesn't work... Is it possible to keep it running with hidden sheets?
Yes it is possible, but depends on what macro does

[swatsp0p]

one solution to both "doubts"... use:

Application.ScreenUpdating = False

'here you can unhide the sheets needed, run your code, then rehide the sheets

Application.ScreenUpdating = True

HTH

Bruce

p.s. Quick English lesson, "Doubt" means "To regard as unlikely". I 'doubt' that is what you meant in your post... most likely you meant "I have 2 problems with excel macros..."

(I respect you for your grasp of my confusing language... and it is the only one I speak, so you have that better than me).
b

[gptechsxm]

Hello Guys

I would like to get some help with this project, to create a macro to select sheet2 if sheet1 is hidden or select sheet1 if sheet2 is hidden
thank you in advance guys for your help

Gptechsxm

[Mordred]

Hi Gptechsxm, please do not post your questions in someone else's thread unless they have something to do with the solutions to that thread. If you would like some help, start your own thread and someone will help you.

Cheers

[mikerickson]

What is the code the OP is having trouble with.
If hiding sheets interferes with the code, it sounds like it might be selecting
Code that uses Select should be avoided
1)hidden sheets can foul it up
2)it slows things down.

If you post your code, we could remove the Selection part and it will work when the sheets are hidden.

[gptechsxm]

sorry guys

this was my fist thread

G
gptechsxm