Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that opens a separate workbook when I right mouse click
but I want it to open to a specified sheet named "Wizard". It opens the workbook by reading the string text displayed in M373 (see below). Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Dim VHM As Workbook Set VHM = ActiveWorkbook Dim exlApp As Excel.Application Set exlApp = New Excel.Application exlApp.Visible = True exlApp.Workbooks.Open Worksheets("DataBase").Range("M373") VHM.Activate Cancel = True End Sub Thanks for any help you can offer. Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy active worksheet to new workbook | Excel Discussion (Misc queries) | |||
When I open a workbook, how can I choose which worksheet opens? | Excel Worksheet Functions | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |