Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-04-2014, 02:55 AM
hanvyj hanvyj is offline Windows XP Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default Encrypted macros wont run...

After rolling out a bunch of worksheets with extensive macro functionality, I found some people are getting the following message:

"This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restrictions on the file."

Excel's suggested solution is to remove encryption. That isn't a solution: I trust my own macros, what I don't want to do is have the users messing around with it and modifying them - that's what I don't trust.



Yet there seems no option to enable them and take the risk of running my macros. There are two options "Disable" (grayed out) and "Disable"

After a quick search it seems I have to do a registry edit to be able to run the code I wrote! This is just crazy, also - I can't edit registry on our IT system PCs. I shouldn't need to edit the registry to have people run a macro. How can they have an encryption system on macros that disables them?

It seems random whether people can use them or not. Some can without any problems and others can't. I got one sheet sent back in an email and now it comes up with the error when I open it. Any idea how I can get the people who are using these spreadsheets to actually be able to run the macros? This didn't happen with excel 2003...

Anyone know of a solution?
Reply With Quote
  #2  
Old 02-25-2014, 06:18 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 975
OTPM is on a distinguished road
Default

Hi
As your macros work on some machine then it can only be down to the configuration of the machines where your macros do not work. You need to speak to your IT Dept to match the config of the machines that do work.
Hope this works.
Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
random pop up wont go away 464646 OneNote 0 05-01-2012 04:34 AM
E-Mails Encrypted wildwilly5891 Outlook 1 10-22-2011 06:16 PM
Outlook PRF settings for TLS encrypted connection scsawwfca Outlook 0 05-19-2011 05:32 AM
encrypted and password protected in 2000 and 2007 Soudabeh Word 0 12-14-2010 06:35 AM
Encrypted Outlook 2007 pst file monkeytennis Outlook 0 01-04-2009 03:11 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft