User Form when opening

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I want to have a "OK or Cancel" type box with some text
when I start my spreadsheet. I would like the box to be
on worksheet 1 with the actual text on worksheet 2. When
the user clicks "OK", it goes to worksheet 2, "Cancel"
will close Excel.
 
You can use form buttons and macros to accomplish this.

1.Right click on the toolbar and selects the forms
toolbar. Click on "Button" and draw a button. When the
dialog box comes up select record and then OK.

2.Go to sheet two and then hit the stop button. That
button will now take you to that sheet every time you hit
it. Do the same for the other button, just do the action
that you want to record and then hit stop.

3.Rename the buttons to what you want them to say.
 
Back
Top