PC Review


Reply
Thread Tools Rate Thread

Cant run macros

 
 
realmichaud
Guest
Posts: n/a
 
      19th Jan 2008
I have a macro

Sub MakeGreen(oShp As Shape)
oShp.Fill.ForeColor.RGB = vbGreen
End Sub

but the run macro dialoge box does not even see it. i have created it from
the create macro, then filled in the rest of the code

does anyone know what I am doing wrong?
 
Reply With Quote
 
 
 
 
John Wilson
Guest
Posts: n/a
 
      19th Jan 2008
That macro (with a variable declaration) will only work in slide show mode
when you click on a shape. Give a shape (or more than one) an action of run
macro and run the slide show - it will work then!

Hope that helps

John

"realmichaud" <(E-Mail Removed)> wrote in message
news:72B13D26-0918-40FA-AA59-(E-Mail Removed)...
>I have a macro
>
> Sub MakeGreen(oShp As Shape)
> oShp.Fill.ForeColor.RGB = vbGreen
> End Sub
>
> but the run macro dialoge box does not even see it. i have created it from
> the create macro, then filled in the rest of the code
>
> does anyone know what I am doing wrong?



 
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
Run multiple Macros or macros from within other macros ? vbaNEWBIE Microsoft Outlook VBA Programming 2 10th Feb 2010 11:14 PM
internet explore 6 wont run 7 cant be installed firefox wont run and i cant downloadany files from the internet malpert Windows XP Internet Explorer 2 23rd Oct 2006 03:24 AM
Macros Macros Macros - Is there anybody out there who is a whiz? =?Utf-8?B?TXIuIFNtaWxleQ==?= Microsoft Access 2 30th Aug 2005 11:11 PM
Tools>Macros>Security Unable to run Macros Security or Visual Basi =?Utf-8?B?TWlrZSBJbiBPcmxhbmRv?= Microsoft Outlook VBA Programming 2 28th Jun 2005 07:55 PM
Making excel macros run Word macros Matthew McManus Microsoft Excel Programming 1 18th Feb 2004 03:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:04 AM.