Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2015, 01:22 PM
laurieli laurieli is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 64bit
Novice
How to automatically enable the macros upon opening a file with macros?
 
Join Date: Dec 2015
Posts: 5
laurieli is on a distinguished road
Default How to automatically enable the macros upon opening a file with macros?

Hi,



I am wondering how to automatically enable the macros upon opening an Excel or Word file with macros and user forms? So that Users don't have to manually enable them by responding to the Security Warning.

Thanks anyone with suggestions or advice!

Laurie
Reply With Quote
  #2  
Old 12-22-2015, 02:50 PM
NoSparks NoSparks is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

You can't.
Think about it.
You want a macro to run on a machine that won't run macros, not going to happen.
If it did, that would totally defeat everything built into MS Office that protects you, me and everyone else from the nasty macros that can do harm.
Reply With Quote
  #3  
Old 01-14-2016, 07:55 PM
macropod's Avatar
macropod macropod is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by NoSparks View Post
You can't.
You can - by designating the folder the file is in as a trusted location.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-15-2016, 05:43 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Surely the answer is somewhere between the two? I don't do this much and I'm pretty sure macropod knows more about the practical side of it than I do. But generally speaking, you can "sign" the program, and the intended victim — I mean beneficient — can tell his copy of Excel to trust signed documents, and there you are.

Or if there's such a thing as a trusted folder (I didn't know about that one) then once the user has told Excel to trust that folder then you can move ahead of this problem. If this is on a work computer, probably the admins have set up the trusted folder and the user doesn't have any control over trusting or not trusting documents that reside there; you just have to get them to move your program there, or to give you the authority to do so yourself.

I've also been asked, when trying to run one of my own programs from a shared drive, whether I want to make this a trusted document. I infer that if I were to answer Yes it would never ask me again whether to allow macro content in that document.

NoSparks' answer wasn't complete wrong, and the principle he described is basically sound. It's just that there are ways to establish trust BY AGREEMENT.
Reply With Quote
  #5  
Old 01-15-2016, 10:49 PM
macropod's Avatar
macropod macropod is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, you can sign macros too, but the point remains a simple 'no' is wrong. Office even has some default trusted locations. You don't need the macro creator's involvement to create a trusted location for it. For more, see: https://support.office.com/en-us/art...5-4208b3540a62
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 01-16-2016, 12:48 PM
NoSparks NoSparks is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

This question was originally asked in the Excel Programming sub forum so I think it was reasonable to think it pertained to macro programming more so than how to setup Office.

macropod's response was 3 weeks after the fact and, by moving the question to a different sub forum, may have addressed the question that was asked, but the OP never returned so who knows ?
Reply With Quote
  #7  
Old 01-16-2016, 01:42 PM
macropod's Avatar
macropod macropod is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by NoSparks View Post
This question was originally asked in the Excel Programming sub forum so I think it was reasonable to think it pertained to macro programming more so than how to setup Office.
Regardless of which forum the question was originally posted in it involved more than just Excel and the answer is the same. All of Office (and that includes Excel) works with trusted locations and signed macros.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 01-17-2016, 08:56 AM
NoSparks NoSparks is offline How to automatically enable the macros upon opening a file with macros? Windows 7 64bit How to automatically enable the macros upon opening a file with macros? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

'tis unfortunate the OP posted their question in the wrong sub forum and has never acknowledged any replies.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically enable macros upon opening the Word? laurieli Word VBA 2 12-22-2015 02:46 PM
Can we define macros in a way to not misworking after deleting, renaming or moving the source file? tesoke Excel Programming 10 11-13-2015 09:30 AM
How to automatically enable the macros upon opening a file with macros? Macros being stripped from dotm file Brian Muth Word 1 10-09-2012 10:00 PM
How to enable PowerPoint Macros? delete123 PowerPoint 3 03-27-2012 06:56 AM
Can Word automatically do "Finish and Merge" after opening file? DaveBF Mail Merge 1 09-14-2011 07:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.


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