it might be easier just to actually run the macro called Disable.
in VBE, in the project list, dbl-click THISWORKBOOK
in the left combo box above the code, select workbook
in the right combo box above the code, select SHEETCHANGE
If Sh.Range("A1").Value = "stop" Then Disable
(note: DISABLE macro MUST be in the same module with the worksheet code above)
The command buttons work fine. Sub Disable stops the refresh when i press the command button assigned to a macro called Disable. What I am trying to do now is get the refresh to stop if "Stop" appears in A1 OR I press the command button. I thought that linking to the macro would do it but it doesn't.
Hope that makes sense. Any ideas to get this working?