| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how i open another sheet in the same workbook without closing?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping program open even when closing workbook | Excel Discussion (Misc queries) | |||
| How can I set a workbook to open always with a certain sheet I wan | Setting up and Configuration of Excel | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Open workbook on same sheet? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Threaded Mode
