Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I have multiple workbooks open and have a menu to switch be
How do I have multiple workbooks open and have a menu to switch between them?
I need to have approximatly 5 workbooks to use due to the size of the workbooks would negate using just one for all of the sheets. Any help would be greatly appreciated. If you are wondering what I am referancing you could go to traderxl.com and watch the analyzerxl demo and see the tabs at the top of the sheet under addin menu. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I have multiple workbooks open and have a menu to switch be
Here is one I use on my MENU sheet to double click on a cell which has the wb or ws typed in. Right click sheet tabview codeinsert this. If you don't need the worksheet part, simply modify. If wb open it activates. If not, it opens it. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.DisplayAlerts = False Dim WantedSheet As String WantedSheet = Trim(ActiveCell.Value) If WantedSheet = "" Then Exit Sub On Error Resume Next If Sheets(WantedSheet) Is Nothing Then GetWorkbook ' calls another macro to do that Else Application.Goto Sheets(WantedSheet).Range("a4") End If Application.DisplayAlerts = True End Sub Sub GetWorkbook() If ActiveCell.Value = "" Then Exit Sub workbookname = ActiveCell.Value On Error GoTo OpenWorkbook Windows(workbookname & ".xls").Activate Exit Sub OpenWorkbook: Workbooks.Open(workbookname & ".xls").RunAutoMacros xlAutoOpen End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Ken C" wrote in message ... How do I have multiple workbooks open and have a menu to switch between them? I need to have approximatly 5 workbooks to use due to the size of the workbooks would negate using just one for all of the sheets. Any help would be greatly appreciated. If you are wondering what I am referancing you could go to traderxl.com and watch the analyzerxl demo and see the tabs at the top of the sheet under addin menu. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I have multiple workbooks open and have a menu to switc
Thanks Don, but the reasion that I'm asking is that I'm not versed in
programming at all but would like to have something like a comercial app. that I bought. Have you ever heard of TraderXL? If you don't care to look at the Analyzerxl demo on the site "www.Traderxl.com" and you could see what I'm trying to do. I have a group of different spreadsheets that I'm using for a trading journal with a trading worksheet to check to see if the trade is worth getting into. Also I have two profit tracking spreadsheets and another calculation sheet. If their is a way to beable to create the tabs in an addon menu and be able to link different workbooks together I would appreciate the help. Thanks in advance P.S. Sorry about asking the dumb questions. "Don Guillett" wrote: Here is one I use on my MENU sheet to double click on a cell which has the wb or ws typed in. Right click sheet tabview codeinsert this. If you don't need the worksheet part, simply modify. If wb open it activates. If not, it opens it. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.DisplayAlerts = False Dim WantedSheet As String WantedSheet = Trim(ActiveCell.Value) If WantedSheet = "" Then Exit Sub On Error Resume Next If Sheets(WantedSheet) Is Nothing Then GetWorkbook ' calls another macro to do that Else Application.Goto Sheets(WantedSheet).Range("a4") End If Application.DisplayAlerts = True End Sub Sub GetWorkbook() If ActiveCell.Value = "" Then Exit Sub workbookname = ActiveCell.Value On Error GoTo OpenWorkbook Windows(workbookname & ".xls").Activate Exit Sub OpenWorkbook: Workbooks.Open(workbookname & ".xls").RunAutoMacros xlAutoOpen End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Ken C" wrote in message ... How do I have multiple workbooks open and have a menu to switch between them? I need to have approximatly 5 workbooks to use due to the size of the workbooks would negate using just one for all of the sheets. Any help would be greatly appreciated. If you are wondering what I am referancing you could go to traderxl.com and watch the analyzerxl demo and see the tabs at the top of the sheet under addin menu. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Multiple Workbooks | Excel Programming | |||
open multiple workbooks not in same app. window | New Users to Excel | |||
custom menu cross contamination between open workbooks. | Excel Programming | |||
open multiple workbooks at startup | Excel Discussion (Misc queries) | |||
Open Multiple Workbooks or Worksheets | Excel Programming |