Do you have a sheet named "sheet2"?

If yes (after you check the spelling!), post back with the error message. (if
it's subscript out of range, then check your spelling once more).

If you need a macro to print, then record a macro when you print what you want.
You'll have the code.

I'm not sure what a back button would do.

michelle wrote:

What I am trying to do is have a workbook setup with a menu on the first
worksheet. (I have done this before, but I can't seem to get the macro to
work.)

The following is the macro written in the code for one button on the menu.
This doesn't seem to work because I keep getting an error.

Sub WorkBook_Open()
WorkSheets("Sheet2").Activate
End Sub

I would also like to have a back button and a print button on the actual
worksheet.

--

Dave Peterson