I have created a userform to insert 3 numeric values and on click perform the following calculation:

Worksheets("main").Cells(12, 4).Value = (Int(TextBox1.Text) + Int(TextBox2.Text) + Int(TextBox3.Text)) / 3

Yet, when I download and open from intranet it does not work and shows msgbox
"Run time error - 1004" Method 'Worksheets' of object_'Global' failed.

Nevertheless, when I save the excel file locally, this calculation works fine.
Any ideas on my problem?

Thanks in advance!