Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PROFESSIONAL MENUS IN EXCEL 2000
Good morning, I really hope some one can give me some guidance. As a
background, I have touched on VBA but any code examples would be great. I have got lots of seperate Excel workbook for showing my companies monthly reports. I tried to write a single menu which in effect hyperlinks to each book. So far I have a user form on a workbook called Menu with links such as; Private Sub Label15_Click() Application.ThisWorkbook.FollowHyperlink "W:\Marketing\SAS Reports\Marketing\Customer Metrics\Invoiced Value By SIC & Employee Banding.xls" Windows("Report Menu.xls").Activate ActiveWorkbook.Close False End Sub This is as good as I can do (got the code from google). The drawbacks are; Unless, I save it as shared, only 1 person can use it at a time, which means all macros are disabled. Also, the workbooks it links too, all link to access data sources. At the moment, I have to go to each linked workbook independantly to make sure it updates first before going to the menu. Can these problems be sorted out? Also for each workbok, I have linked too, I then have a command button such as; Private Sub CommandButton1_Click() Workbooks.Open Filename:="W:\Marketing\SAS Reports\Report Menu.xls" Windows("Product Line Metrics.xls").Activate ActiveWorkbook.Close False End Sub Although, it works and it does return to my menu workbook, it leaves the "linked to" workbook" open even though my code tries to shut it. I would rather have used some of the custom menu code, but can not see how it works. Could some one help me please? it would be great to get this methodolgy working properly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
free pre-installed Office interfers with Office 2000 professional. | Excel Discussion (Misc queries) | |||
exel error 1706 microsoft office 2000 sr-1 professional | Excel Discussion (Misc queries) | |||
cancel Microsoft office 2000 SR-1 Professional | Setting up and Configuration of Excel | |||
How do I Set up a Invoice in Microsoft Office 2000 Professional (. | New Users to Excel | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) |