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

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



--
Gary''s Student - gsnu200829


"okiearcher" wrote:

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