Automatic running of Macro for the whole spreadsheet
 

Is it possible to have a macro that runs every minute or whenever anything
changes in the whole spreadsheet for the purpose of re-publishing
to a website?

Automatic running of Macro for the whole spreadsheet
 

To run a macro every minute, use the OnTime method. See
www.cpearson.com/excel/ontime.htm for more information. To run a
macro when anything in the workbook changes, use the following
code in the ThisWorkbook code module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range)
MyMacro ' change macro name as required
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Rob" wrote in message
...
Is it possible to have a macro that runs every minute or
whenever anything
changes in the whole spreadsheet for the purpose of
re-publishing
to a website?