Auto Value When Opening Workbook

[Pondcroft13]

Hi All,

When opening a workbook I want excel to automatically enter the value '1' into a cell of a certain sheet - for example cell A1 in sheet 'Mechanics'.

How do I do this?

 

[ColinKJ]

Hi Pondcroft13,

Try:

Private Sub Workbook_Open()
Sheets("Mechanics").Cells(1, 1) = 1
End Sub

ColinKJ