I have a simple spreadsheet with 5 fields on it that is to be used as an entry form for printing. The idea is the user just opens the spreadsheet, fills in the fields, and clicks on the PRINT button at the bottom of the spreadsheet to print the simple form. I am using excel 365 and I put some simple VBA code on the spreadsheet to initialize the 5 fields as the spreadsheet opens, but it does not initialize the fields? This is the code I am using:
Private Sub AutoOpen_()
Range("C3").Select
Range("C3").Value = " "
Range("B5").Select
Range("B5").Value = " "
Range("F5").Select
Range("F5").Value = " "
Range("B9").Select
Range("B9").Value = " "
Range("B10").Select
Range("B10").Value = " "
Range("B11").Select
Range("B11").Value = " "
MsgBox ("AutoOpen")
End Sub
I have also placed the spreadsheet in a trusted directory and saved it as an xlsm type spreadsheet. I don't understand why it is not working?