here's an example

Private Sub workbook_open()
Sheets(2).Range("B19").Formula = "=B17"
End sub
Ive tried it in the module and where you can code for the indivudual page. Do you have to create a macro?