I am writing a
VB macro for an excel spreadsheet. I want certain cells to
contain text and numbers when someone opens the workbook. Also I want a
button to be shown when someone opens the workbook. I do not want to use a
userform but I want the button and the text på be directly on the
spreadsheet. I seem to fail with the workbook open sub. My code for this part
is:
Private Sub Workbook_Open()
Worksheets("Setup").Range("b19") = "open"
Worksheets("Setup").Range("b20") = "sesame"
End Sub
I do not know how to get this sub to perform the instructions. help!!