it was a simple macro from one sheet to another:
Sub TEST1()
'
' TEST1 Macro
' Macro recorded 01/06/2006 by KMC
'
'
Sheets("Sheet3").Select
End Sub
however once the worksheet was hidden the macro no longer worked
--
murph306
------------------------------------------------------------------------
murph306's Profile:
http://www.excelforum.com/member.php...o&userid=35000
View this thread:
http://www.excelforum.com/showthread...hreadid=547392