cyberkiwi
asked on
How to open an .xlsm file with Macros ENABLED, always?
By default, all documents in Excel 2007 open with a security warning. By the 100th time in the year, you would have thought Microsoft/Office/Excel has marked the file as safe.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Eat my shorts.
Oh, I know! Remove the macros!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Darn...I should have held out for 25 pts!
Is it too late to jump in?
Try this link: http:#a35269307
Or, a really good E-E discussion had a solution for this - go here, and scroll down to the bottom - there's a link there you can use: http:/Q_26923514.html
Cheers,
Dave
Try this link: http:#a35269307
Or, a really good E-E discussion had a solution for this - go here, and scroll down to the bottom - there's a link there you can use: http:/Q_26923514.html
Cheers,
Dave
ASKER
I'm glad I held out for more help. dlmille your links gave the most bang for comment - the 2nd one was really helpful. I have increased the points to 23 so that I can equitably distribute enough points to each helper when the time comes.
I will hold out a bit more to see if anyone has a better solution. I have to say that Rob has the inside running on this.
@zorvek http:#a35269602 - I'm sorry but my macros track my points at EE in real time and draws a nice graph after pulling data from EE. I needz them.
[fyi - This is a real question. I followed Rob's article and have done it in all of <2 minutes... pretty good]
I will hold out a bit more to see if anyone has a better solution. I have to say that Rob has the inside running on this.
@zorvek http:#a35269602 - I'm sorry but my macros track my points at EE in real time and draws a nice graph after pulling data from EE. I needz them.
[fyi - This is a real question. I followed Rob's article and have done it in all of <2 minutes... pretty good]
yay! My outdated article got its ~2 minutes of fame...oh, wait...that's supposed to be 15 minutes...hmmm...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
See, I knew there was a GREAT answer waiting to happen. You've saved the day again, my good sir.
ASKER
Office button
Excel Options button (bottom right in menu next to Exit)
Trust Center (2nd from bottom on the left)
Trust Center Settings button (somewhere on the right)
Trusted Locations (2nd from top on the left)
Add new location!!!
Thanks to Brad
Excel Options button (bottom right in menu next to Exit)
Trust Center (2nd from bottom on the left)
Trust Center Settings button (somewhere on the right)
Trusted Locations (2nd from top on the left)
Add new location!!!
Thanks to Brad
ASKER
Brilliant - exactly what I was looking for. No need to tinker with certificates.
Thanks Rob also for the article, and Kevin for the attempt. You both get as many points as offered when you entered the question.
Thanks Rob also for the article, and Kevin for the attempt. You both get as many points as offered when you entered the question.
Yea - when I got Excel 2007, I made every drive I had a Trusted Location, lol.
Where's my 3 points - I sent a link to the right answer?
Were's the "request attention" button?
:)
Cheers,
Dave
Where's my 3 points - I sent a link to the right answer?
Were's the "request attention" button?
:)
Cheers,
Dave
Cool answer BY. Now I just need to add every directory on my hard drive where I may start a new workbook :)
ASKER
Ima gonna to wait and see if there are other experts who can come up with a non-certificate way to solve the problem.
I am upping the points to 21 because it seems this could be a difficult challenge.