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