LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 78
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro button that others can see Newbee Excel Worksheet Functions 2 May 28th 08 05:17 PM
Macro button Chip Smith Excel Discussion (Misc queries) 4 May 16th 08 03:23 AM
Macro Button! help! TxcPhtm Excel Discussion (Misc queries) 1 February 27th 08 11:26 PM
Using Macro to sort without clicking on macro button dd Excel Discussion (Misc queries) 3 May 3rd 07 06:00 PM
use macro button to run macro in protected sheet earl Excel Discussion (Misc queries) 3 February 26th 06 10:21 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"