View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
april27 april27 is offline
external usenet poster
 
Posts: 27
Default show info when workbook opens

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!!