Well, you can use the following macro code to open another sheet in the same
work book
#
Sheet2.Activate
#
Place this code on the command button click event so that when you click the
button you will be switched to another sheet
Note that this will switch between the sheets in the same work book(to sheet2
from current sheet)

Have a nice time

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com