PC Review


Reply
Thread Tools Rate Thread

2 questions: Macro Mapping & Active Chart

 
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      18th Jul 2007
I hope that someone can help. I have an Excel sheet with Buttons (each tied
to a Macro) that affects the Chart on the page.
The problem is that this will be massly distributed to numerous people, and
the people will likely copy & paste that tabs to their liking, which will
cause errors with the buttons & macros.

Herere are my 2 specific questions:
1. Is there a way to tie a BUTTON to a MACRO for the 'current active Excel
file'?
When assigning a MACRO, it kind-of hard-codes the current file name into
the assignment, which can cause issues.
2. How do I select the ACTIVE CHART on the ACTIVE WORKSHEET?
Currently, I have it set as: ActiveSheet.ChartObjects("Chart 1").Activate
However, it may not always be Chart 1. :-(

Thanks,
Mike

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Antivirus, firewall & drive mapping questions nobodys@home.net Windows XP Networking 3 21st Apr 2006 02:27 PM
Wingdings Keyboard Mapping Chart? =?Utf-8?B?QmlsbDQ1?= Windows XP General 6 19th Aug 2005 07:02 PM
Mapping Lpt1 to an active directory printer object =?Utf-8?B?UGF1bCBD?= Microsoft Windows 2000 Active Directory 1 30th Nov 2004 08:27 PM
ICF+Active Directory+NetworkResource mapping ? WJ Windows XP Security 2 12th Dec 2003 01:42 PM
Active Drive Mapping Utility Not Working =?Utf-8?B?VGltIGF0IEZDQw==?= Microsoft Windows 2000 Active Directory 1 16th Nov 2003 11:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:08 PM.