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?

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" <Rob@discussions.microsoft.com> wrote in message
news:A242B69A-C5C6-4B96-8832-A732CB883F00@microsoft.com...
> 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?
>