WorksheetModule

[Kyle]

How do I create and ran a worksheet module. Can someone
provide me with an example. I couldn't find any in ms xcel
help.
Thanks.

 

[Norman Harker]

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.