#1
|
|||
|
|||
Run Macro & Activate shape
I know that I can run a macro by clicking a button and/or run the macro automatically once you open the xls file. However, I want to know
(1) how I can run the macro in a cell when it meet a specific condition. For example IF $C2 = 5, run macro 1, “ “ . (2) I have a shape in a cell where a macro will be executed if the user clicked it. How can I make this shape active only if meet specific criterion? For example, IF $B1 = 3, shape1=active, shape1=not active . I appreciate your help. Thank you. |
#2
|
|||
|
|||
If you want these macros to run themselves, then you can use event macros to check these sheet values anytime a value is manually changed on that sheet. Would that suffice? It would be a different macro that checked these cells if any change occurs on ANY sheet.
1) Would the macro you run result in C2 no longer being equal to 5, because if this macro runs anytime a change occurs anywhere on the sheet and C2 value isn't changed by the macro results, then that macro would get triggered over and over again. 2) The multiple-trigger problem isn't as big a deal on this one since it would simply be making a shape visible/invisible, right? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Activate Office XP on Windows 7? | scradock | Office | 1 | 02-12-2012 09:01 PM |
can't activate remove page numbers function | gsjackson | Word | 5 | 01-16-2012 05:30 PM |
Shape Objects | Space Cowboy | PowerPoint | 4 | 10-04-2010 07:14 PM |
How to Activate Office 2010 Trial | phillipduran | Office | 2 | 08-06-2010 09:24 AM |
how do I activate office basic? | madyfb | Office | 1 | 05-21-2009 11:18 AM |