Hi Kyle!
Select the worksheet that you want the module in
Right click the Worksheet Tab
You'll now be in the Code window for that sheet.
To creat sheet event subroutines,
In the left drop down above the code window select Worksheet
In the right drop down select the type of event you want to handle
This process ensures a correct "topping and tailing" of the event
subroutine.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
