Can I change my security setting?

B

brucesw

Active Member
Joined
Nov 12, 2002
Messages
304
Office Version
  1. 365
Platform
  1. Windows
Hello World, esp. the lucky sports fans in Germany,

We've just switched to Excel 2003 and the boffins have created a 'profile' that controls a couple of settings in my Excel. One item is 'medium' security.

In reality, with all the firewalls etc we have here at work I'll ALWAYS enable macros given the chioce upon opening a workbook. Call me stupid but ...

What vba code can I run after opening Excel to change my security level to 'Low'?

Thanks in advance, Bruce
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
What vba code can I run after opening Excel to change my security level to 'Low'?
Click to expand...
You cannot do that with VBA code, it needs to be done manually.

From the worksheet menu, click Tools > Macro > Security > Security Level tab, select "Low" and hit OK.

By the way (referring to your "call me stupid" line), I have my setting on Low also, because if I don't trust the sender I don't open the workbook. Low gets a bad rap more than it should, it is a prefectly viable option for users who manage their computer activity with common sense.
 
Upvote 0
Bruce,

It is a manual change only - would conflict with security otherwise. So, Tools, Macro, Security, Low.

regards,
Fazza
 
Upvote 0
Thanks, I thought as much.

The quickest is to display the Visual Basic toolbar which has a 'Security' button to save a few clicks.

I wonder how much was spend on the firewall if they still don't trust it....
 
Upvote 0
You must log in or register to reply here.

Similar threads

MPW
  • Solved
How can I determine the dpi zoom settings for the primary monitor?
Replies
6
Views
1K
MPW
MPW
R
  • Question Question
How To Make Workbook Expire After Date Set In File On Website (Text Document or HTML File)
Replies
0
Views
750
ryancdavis
R
M
  • Question Question
can I add a vba to a page so that it updates a date if I save the page after altering it?
Replies
2
Views
229
matelot2
M
9tanstaafl9
  • Question Question
Can't set application.screenupdating = False ... Going insane...
2
Replies
12
Views
5K
9tanstaafl9
9tanstaafl9
G
  • Question Question
How to avoid message "Enable Macro" without changing security level
Replies
3
Views
902
Ruddles
Ruddles

Forum statistics

Threads
1,226,240
Messages
6,189,820
Members
453,571
Latest member
Zale

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top