Macros with hidden sheets!

[Perini 9]

Hi there,

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

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

Many Thanks

Regards to you all

Perin

 

[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... I
it possible to keep it running with hidden sheets?
Yes it is possible, but depends on what macro doe

 

[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