View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] peterfarge@hotmail.com is offline
external usenet poster
 
Posts: 32
Default Excecute Macro if cell changes

Hallo Guys,

I have created a new table at runtime and want excecute some code if
the user clicks on a cell. How can I do that?

This doese not work:

Dim oWKS as Worksheet
Set oWKS = ThisWorkbook.Worksheets.Add
oWKS.cells(1,1).onAction = "MyMacro" ' Error