Inserting code in Worksheet.Change

O

okiearcher

Hi all.

I am creating a new worksheet with VBA code from Access 2003. I copy records
to a range on the sheet, do cell formatting, create list and validation, etc.

What I need to do is insert some code in the new sheet's Change event.

Is there an easy, or correct and proper way to do this?

Thanks.
Keith
 
G

Gary''s Student

easy:


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. on the left pull-down select Worksheet
4. on the right pull-down select the type
5. paste you material in

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window
 
Top