Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXCEL MENU NOT WORKING PROPERLY (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 | |||
VBA Excel code not working properly (HELP!) | Excel Discussion (Misc queries) | |||
Text wrap not working properly in Excel | Excel Discussion (Misc queries) | |||
Why is my tab key not working properly any more in Excel? | Excel Worksheet Functions | |||
Excel ODBC add-in not working properly | Setting up and Configuration of Excel | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions |