Run Macro If Cell Value = 1

Hi

I have a spreadsheet with several worksheets and I need to run a macro to copy a webpage and paste it into one of the worksheets. This I am doing fine already. What I would like to do is have the macro run automatically if a cell equals a certain value.

The first Worksheet is named "Data" and if the value of cell AE1 = 1 I want the macro to activate. The second worksheet is named "Arg" and it is here that i want the webpage pasted.
Here is the code I have:

Please Login or Register  to view this content.

what have I done wrong? Any help would be appreciated.

Doug

in "ThisWorkbook" add the following code:

Please Login or Register  to view this content.

then in a module, insert your macro. for example

Please Login or Register  to view this content.

I think you'd be better off using a webquery (menubar/data/external data, webquery). one of its properties is the refreshtime.