i want to open another sheet in same workbook and link between the sheets in
same workbook. how can i do it? while opening the workbook having several
sheets, how wo open the other sheet in same workbook without closing the
workbook?

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

If you want to have two open copies, with either same or dif sheets displayed:
1) Click on Window tab on upper portion of Screen, then click New Window.
2) The new (2nd) window of your current Sheet should default open, go back
to Window up top and now click, Compare Side by Side with (whatever your
title is).
3) From here, you can do an over/under viewing of both windows, or a
side/side viewing. You can also view one sheet on one window and another
sheet in other window at the same time.


"kamrul" wrote:

i want to open another sheet in same workbook and link between the sheets in
same workbook. how can i do it? while opening the workbook having several
sheets, how wo open the other sheet in same workbook without closing the
workbook?