On 2002-05-07 06:15, TsTom wrote:
From your Excel worksheet, rightclick on the
Excel icon immediately left of your file menu item(Upper left hand corner), choose "View Code", paste this code there.
If the procedure already exists, then just paste the one line into the existing procedure.
Should end up in your workbook class module.
Tom
[/quote]
Hi,Tom,
I have insert your macro on the place it must.But when I run the macro(open the workbook) then there is another sheet that is hidden and not Sheet1
Any idea?
Thanks