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