Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2012, 08:28 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default URGENT: macro icons don't work when 'save as'

Hi
I've customised my tool bar to include icons for macros



Works fine for my 'Test' doc, however when I save this docment as something else the macros don't work and I get an error message:

"macro cannot be found or has been disabled because of your security settings"

Any ideas of what I can do to resolve this, as really people will start off with my blank document (which is effectively a template) and then save it as something else before using...

Cheers

Andy
Reply With Quote
  #2  
Old 11-12-2012, 09:36 AM
JohnWilson JohnWilson is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

There's no reliable way to do this without writing an AddIn Andy.
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 11-12-2012, 09:47 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default

Thanks John...

Are add-ins easy to do?

If not, do you have a suggesion for me? it seems to work ok if macros are stored in a separate PowerPoint doc eg called 'macro' if this is open when the other doc (which can be called anything) is also open...

Also, are you able to help me with another query (amending the code you've already given me slightly)...the query is posted as " URGENT VBA needed for placing image on page”?


Very nearly there, thanks for your help

Cheers

Andy
Reply With Quote
  #4  
Old 11-12-2012, 10:04 AM
JohnWilson JohnWilson is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

There is of course a learning curve. see here for help.

We have a freebie AddIn kit on the same page which makes it easier.
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 11-16-2012, 09:19 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default

Hi John, thanks for this
I've downloaded the addin and followed the instructions..

I've also copied all of the modules and code into my PowerPoint 2010 Macro enabled template which has been formatted with our company logo and in correct font etc

But I can't see useful macros tab?

Are you able to advise what I need to do to apply these macros to a preset template?

Cheers

Andy
Reply With Quote
  #6  
Old 11-16-2012, 10:29 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default

Thanks John...have sussed it...cheers

Is it possible to add icons to the ribbon, rather than have them listed under a 'my macros' tab?
Reply With Quote
  #7  
Old 11-18-2012, 02:58 AM
JohnWilson JohnWilson is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

It is certainly possible but you would need to learn a lot more about XML. Google ribbonX or buy the book
RibbonX - Customising the Office 2007 Ribbon
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #8  
Old 11-21-2012, 03:35 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default

Hi John
Good morning
The add-in is great...are you able to help me so I can set it up like this:

"PowerPoint doc 1" = 5 macros
"PowerPoint doc 2" = 3 macros

Many thanks

Andy
Reply With Quote
  #9  
Old 11-21-2012, 08:20 AM
JohnWilson JohnWilson is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Hi

The Free AddIn just comes "As Is"

Obviously we can do what you need (or make ribbon buttons) but it wouldn't be free.

I get 100% of my income from coding and while I'm very happy to help others I have to live!
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #10  
Old 11-21-2012, 08:21 AM
AndyDDUK AndyDDUK is offline URGENT: macro icons don't work when 'save as' Windows 7 64bit URGENT: macro icons don't work when 'save as' Office 2010 64bit
Advanced Beginner
URGENT: macro icons don't work when 'save as'
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default

Ok, fair do's...thanks very much.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT: macro icons don't work when 'save as' Macro to save as pdf with ability to choose save as folder rvessio Word VBA 4 07-25-2016 12:37 PM
URGENT!!! Powerpoint Image Formatting and Positioning Macro mertulufi PowerPoint 5 12-20-2011 10:14 AM
Save attachment function won't work in Outlook 2007. WLVanS Outlook 0 09-16-2011 12:30 PM
Macro Won't Save lou0915 Word VBA 2 10-17-2009 08:13 PM
URGENT: macro icons don't work when 'save as' Need urgent help .. lost 6 hours of work .. assignments due in tomorrow Phatmat Word 1 10-15-2009 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 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