Microsoft Office Forums VBA Macro shared amongst different computers on a network

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2013, 09:39 AM
sbarron76 sbarron76 is offline VBA Macro shared amongst different computers on a network Windows 7 64bit VBA Macro shared amongst different computers on a network Office 2007
Novice
VBA Macro shared amongst different computers on a network
 
Join Date: Apr 2013
Posts: 7
sbarron76 is on a distinguished road
Default VBA Macro shared amongst different computers on a network

Good afternoon. I have been asked to to update a word doc to show different fields based on a selection in a check box. All this works fine, i used VBA to hide and unhide the fields based on the check box selection and all works well....on my machine.

I was not aware until today that with word 2007 my macros do not work on another user's machine (we don't use VBA in word often at all, this was the only solution i could come up with based on their needs). Unlike previous versions, where a user is prompted to enable macros upon opening a macro enabled document, it seems like word 2007 has made this more, if not too secure.

This document is shared on a network drive that any user can access and fill out. From my research around the net today, it sounds like there are a bunch of steps a user has to do in Word to be able to view the macro i built. Currently if another user opens my document on their machine, you can't even see the macro. To put it mildly, i work with a bunch of non-technical people, and telling them they have to go and install in add in or make changes to their normal.dot file or change trust locations is a non-starter. I might as well be speaking a different language.



Is there not a simpler way to create a word doc with some vba and have it available on a network share where anyone who opens the document has the macro available when they choose that check box option? Any help would be appreciated.

Thanks!
Reply With Quote
  #2  
Old 05-09-2013, 03:51 PM
macropod's Avatar
macropod macropod is offline VBA Macro shared amongst different computers on a network Windows 7 64bit VBA Macro shared amongst different computers on a network Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your description suggests your users have their macro security set too high and/or the file is not being saved to a trusted location. Macro security setting in Word 2007 & later are essentially the same as for previous versions. Your users should go to Word Options>Trust Centre>Macro Settings and set the security level to the 2nd option (disable all with notification). That means they'll be asked whether to allow macros in a document to run. If you store the file in a trusted location, the macros will be available without that prompt.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-10-2013, 05:18 AM
sbarron76 sbarron76 is offline VBA Macro shared amongst different computers on a network Windows 7 64bit VBA Macro shared amongst different computers on a network Office 2007
Novice
VBA Macro shared amongst different computers on a network
 
Join Date: Apr 2013
Posts: 7
sbarron76 is on a distinguished road
Default

Hi Paul, thanks for your response. It's not the macro security issue, i have checked with my testers and they all have it set to the lowest setting (enable all macros), they were advised to when we upgraded to word 07 as we have numerous documents and apps that run macros. The document is stored in one location and users access it through a dashboard type program created in access. They don't store documents locally. So with a trusted location, would each user have to set this file share up as a trusted location? It seems that this would be the only way to get this working, otherwise, we won't be able to use the macros i built and would have to find alternative means.
Reply With Quote
  #4  
Old 05-10-2013, 10:14 AM
sbarron76 sbarron76 is offline VBA Macro shared amongst different computers on a network Windows 7 64bit VBA Macro shared amongst different computers on a network Office 2007
Novice
VBA Macro shared amongst different computers on a network
 
Join Date: Apr 2013
Posts: 7
sbarron76 is on a distinguished road
Default

Hi Paul, I actually have resolved this issue. Luckily the dashboard program we use to launch these documents actually adds the location to the trust centre when you install this tool. So that was the issue, was not having the file in a trusted location. It is working now since i moved the file to the server. I am sorry to have wasted your time, i had no idea that this was setup until talking to the developers of this tool. Thank you again for taking the time to respond.

Regards,
Sean
Reply With Quote
  #5  
Old 05-10-2013, 03:10 PM
macropod's Avatar
macropod macropod is offline VBA Macro shared amongst different computers on a network Windows 7 64bit VBA Macro shared amongst different computers on a network Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by sbarron76 View Post
i have checked with my testers and they all have it set to the lowest setting (enable all macros), they were advised to when we upgraded to word 07 as we have numerous documents and apps that run macros.
That is really unwise - which is why MS has '(Not Recommended)' against that option. What you should do is to create/designate a trusted location in which to store files containing the approved macro or digitally sign the documents, so they can be run without the prompts (if that's what you want), and at most have the default setting to the second option. A trusted location could be a single folder or a group of folders on the network, and you can have more than one trusted location.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Macro shared amongst different computers on a network Could not update file on the shared network drive with Office 2010 aldo4u Word 7 07-24-2013 07:56 AM
Shared file\macro & IP address ibrahimaa Excel Programming 0 01-29-2012 09:08 AM
VBA Macro shared amongst different computers on a network Macros on other computers judicial85 Word VBA 3 03-06-2011 06:57 PM
VBA Macro shared amongst different computers on a network Working with Outlook on 2 Computers Help Aquanut Outlook 8 02-02-2011 09:54 AM
VBA Macro shared amongst different computers on a network Error Copying file or folder - Drag-N-Drop--> Network Shared Kris.Fulgham Outlook 1 10-17-2005 09:02 AM


All times are GMT -7. The time now is 06:48 PM.


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