![]() |
Please help with button macro
I have this code in a button in excel:
Sub open_fp_wrkbk() ' ' open_fp_wrkbk Macro ' Macro recorded 10/30/2008 by hp90673 ChDir "K:\Readiness and Customer Ops" Workbooks.Open Filename:="K:\Readiness and Customer Ops\FP_dash.xls" ActiveSheet.ChartObjects("Chart 7").Activate End Sub It is a table of contents button and it opens a file. It also keeps the file active in case the user clicks the same toc item again, so that they don't get the 'this file is already open' or an error. I want to apply this to other buttons but I know nothing about VB. In the second line where it keeps the file active, it is calling the file not by it's name but "chart7". Where is it getting this name from. What should I put in the last line to keep FP_dash.xls activated for the user. I have tried, and I am just very frushtrated. Thanks. |
All times are GMT +1. The time now is 10:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com