View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Douglas[_2_] Douglas[_2_] is offline
external usenet poster
 
Posts: 2
Default Automate a macro based on the value of a cell? (call Sub)

Here it is:

1. I have a muti-sheet workbook

2. I have buttons on several sheets that call Subroutines
that assign default values -- they work fine.

The problem: How can I run one of those macros/Sub
automatically when some cell goes, say TRUE to FALSE?

Specifically, from Sheet1 I want to run the code attached
to Button2 on Sheet2.

Help,

Doug