Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2012, 09:29 AM
ibrahimaa ibrahimaa is offline Run Macro & Activate shape Windows Vista Run Macro & Activate shape Office 2007
Advanced Beginner
Run Macro & Activate shape
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Red face 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.
Reply With Quote
  #2  
Old 01-21-2012, 02:14 AM
JBeaucaire JBeaucaire is offline Run Macro & Activate shape Windows XP Run Macro & Activate shape Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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?
Reply With Quote
Reply

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
Run Macro & Activate shape can't activate remove page numbers function gsjackson Word 5 01-16-2012 05:30 PM
Run Macro & Activate shape 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
Run Macro & Activate shape how do I activate office basic? madyfb Office 1 05-21-2009 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft