editing code with code

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

Hi All

I am trying to add a new worksheet and in that worksheet I
am trying to place a piece of code that deletes it when
you deselect it.

As a starting block I have looked at code cleaner to try
to work out how to do this but it seems to use things of
type VBIDE.VBProject unfortunately I don't seem to beable
to work out where this is declared.

Could someone please punt me in the right direction.

Thanks heaps
Jase
 
I think you'd be better off writing (permanent) code at the workbook
level. Take a look at the events in the ThisWorkbook code module e.g.
Workbook_SheetDeactivate.
 
Back
Top