Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· openaiHugging Face Suzhen/CodeChat

How can I write a VBA code that activates when a sheet is opened, forcing Range B1, A22,…

  1. User

    How can I write a VBA code that activates when a sheet is opened, forcing Range B1, A22, F22 and I1:J20 to calculate

  2. Assistant

    You can use the Worksheet_Activate event in VBA to trigger the calculation of particular ranges when the sheet is opened. Here's an example code for your requirement:

    Private Sub Worksheet_Activate()
        Range("B1").Calculate
        Range("A22").Calculate
        Range("F22").Calculate
        Range("I1:J20").Calculate
    End Sub
    

    Copy and paste this code in the code module of the sheet that you want to work with. This way, every time the user clicks on the sheet tab or opens the sheet, the code will run and calculate the specified ranges.