Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros with hidden sheets!
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 -- Perini ----------------------------------------------------------------------- Perini 9's Profile: http://www.excelforum.com/member.php...fo&userid=2472 View this thread: http://www.excelforum.com/showthread.php?threadid=38292 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros with hidden sheets!
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 -- anilsolipura ----------------------------------------------------------------------- anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=38292 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros with hidden sheets!
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 -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=382921 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hidden sheets | Excel Discussion (Misc queries) | |||
Hidden Sheets | Excel Worksheet Functions | |||
Unhide Worksheets (hidden via macros) | Excel Discussion (Misc queries) | |||
running macros on hidden sheets? | Excel Programming | |||
Hidden? macros | Excel Programming |