Exiting a macro if not physically on a certain worksheet

Hi Guys,
I have set up an Excel workbook that contains several pages to run a macro on a specific page every 5 minutes. If I am manually looking at another page when the macro in question runs the worksheet flashes up an error as I am not on that specific page.

I would very much like the macro NOT to run if I am looking at another page. Is there a way of exiting the macro in question if that specific page is not open in the worksheet.

Kind of like If the sheet1 is not being viewed – exit sub.

Probably a very simple answer – many thanks in advance,

John

Hi, John,

maybe a simple If-Statement could be enough:

Please Login or Register  to view this content.

Ciao,
Holger