Hi, I have a workbook with 4 worksheets, one of which is called Crypto Rates. Its very rare i access this worksheet as it just pulls in data from a websource. There are other cells throughout the workbook that reference the data collected. I have the following makro that auto updates the data Sub UpdateCrypto() Range("'Crypto Rates'!E2:E1000").Select Application.CalculateFullRebuild Application.OnTime DateAdd("s", 10, Now), "UpdateCrypto" End Sub However, it only seems to runs when i have the Crypto Rates worksheet open. Is there a way to make the Makro run independently of what worksheet i have selected / open. Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Run mackro on different worksheet

Thread starter pigsfoot
Start date Sep 7, 2017
Tags

crypto data rates run worksheet

pigsfoot

Board Regular

Sep 7, 2017

Hi,
I have a workbook with 4 worksheets, one of which is called Crypto Rates. Its very rare i access this worksheet as it just pulls in data from a websource. There are other cells throughout the workbook that reference the data collected.

I have the following makro that auto updates the data

Code:

Sub UpdateCrypto()
    Range("'Crypto Rates'!E2:E1000").Select
    Application.CalculateFullRebuild
    Application.OnTime DateAdd("s", 10, Now), "UpdateCrypto"
End Sub

However, it only seems to runs when i have the Crypto Rates worksheet open. Is there a way to make the Makro run independently of what worksheet i have selected / open.

Thanks