http://www.experts-exchang
The above question was resolved and working last night using the macro shown. This morning I let MS run its security updates. Now when I try to open the workbook I get a notice that macros are turned off (when the level is set to High) or I must specifically authorize macros (when level is set to Medium). This was not true before the updates.
I do want high level macro security, but I do not want to authorize this macro every time I open the workbook. Can I "sign" that I am the one who put the code in the macro? or in some way tell Excel this macro -- the one referenced above -- is always ok?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I suspect something more than a "bug" being fixed. I have other workbooks
that have macros that I put in them,
(for example, http://www.experts-exchang
and they don't object to macro security when I open them. So why/how is this macro different than the other? I think there must be a solution other than signing.
If your macros are in an add-in or in your personal macro workbook, then they should run even with security set to high, assuming you have the option to trust all installed add-ins and templates.
Otherwise, the behaviour you have now is what you should be seeing with High or Medium security.
Regards,
Rory
I right clicked the sheet tab and picked View Code, then I pasted the macro code for High/Low there. Is that an add-in?
The error level is set to Medium, and I have approved All Add-Ins and access to Visual Basic projects. The error message I get is attached.
The workbook works fine when I pick "enable macros" in the error message.
xls error when opening
Hmm... but the "offending" workbook was originally created on a Win2000 machine using
Excel 2000. I moved it to the XP machine and made some modifications (not involving macros). However, it was on the XP machine that I created and added the 2 macros -- one for a static 'today's date" and the other for High/Lows. Would that explain it?
It shouldn't matter which version it was created in, only where it is. For a (horrendously) detailed explanation of the security levels see this MSDn article: http://msdn.microsoft.com/
Es
Regards,
Rory
Business Accounts
Answer for Membership
by: asyscokidPosted on 2009-10-17 at 09:27:59ID: 25596348
You don't specify what version of Excel. If it's Office XP, this may help.
http://msdn.microsoft
I needed help with an Outlook XP macro once, and it wouldn't run until the expert helping me pointed me to that info on "code signing".