Default Cell L1 to "N" when open workbook

[howard]

I have a sheet "Sales Estimate" and Cell L1 can be set to "Y" or "N" manually

I would like cell L1 on sheet L1 to be set to "N" each time the workbook is open


Your assistance is most appreciated

 

[Michael M]

Put this in the "This Workbook" module

Sub Workbook_open()
Sheets("Sales Estimate").Cells(1, 12).Value = "N"
End Sub

 

[howard]

Thanks for the help , Michael

 

[Michael M]