Macro Security (saying That The Macro Security Level Is Too High)

Nov 18, 2008

I have a sheet that will not let me use macros. I can record them, but when I go to use them it says that the Macro security level is too high. I change it to Medium or Low but it doesn't make a difference.

The same spreadsheet works with Macros on another computer, but not my main one.

View 5 Replies


ADVERTISEMENT

Display Macro Security Level Code

Sep 6, 2006

Although not a complete novice, I am fairly new to EXCEL/VBA.
Is there a script that can be embedded into an EXCEL workbook that checks the Macro security of the PC, and if set to HIGH, shows a message that states that "Macro security is too high to open this workbook".
With security set to high, Excel will open my w/ book, but not run any of my checks that are set in the module. So a "catch 22" really, I need the macros to run to that it is being opened on an authorised computer etc, but if security is set to HIGH, then they don't run, similarly, if I put a macro in to check the macro setting, it won't run unless the security is set to medium.

View 9 Replies View Related

Excel 2007 :: How To Detect Macro Security Level

Jul 24, 2014

is it possible through vba code to determine the macro security level of Excel 2007 and inform the user. I tried the code below , it is executed when the workbook is opened, but it doesn't work.The code below is executed only when the macro security level is "Low". My goal is at least to inform , with a msgbox function, to change manually the security level.

Code:

Dim secAutomation As MsoAutomationSecurity
Dim zLevel
As String
secAutomation = Application.AutomationSecurity
Select Case secAutomation

[Code]....

View 1 Replies View Related

Macro To Delete Vba Code - Macro Security Warning

Feb 7, 2008

I have recently grabbed the very helpful "Macro to delete VBA code" from this site, and it's working but with one small problem.

My worksheet runs a lot of code, then deletes all macro code and saves itself.

The problem is the next time i open I still get the macro security warning!

I've checked thoroughly and there is definatley no vba left anywhere.

If I open the document, enable macros, and save it, then open it again, I no longer get the warning.

View 9 Replies View Related

Are You Sure - Security For Macro

Aug 7, 2007

I have a spreadsheet that I regularly have to clear the data and start over on, so i recorded a macro for clearing this rather long sheet with only one cllick.

My problem is that i am not the only person who will use this sheet, if They click the control button by mistake they will clear their work and you cannot undo it. I was wondering if i could make it ask "are you sure" kind of like the save option when closing an unsaved document.

View 11 Replies View Related

Macro Security

Jun 29, 2006

If there is code attached to a worksheet, not necessarily in a macro, does the macro security still have to be low to use it??

View 3 Replies View Related

Xl Macro Cant Email Due To Outlook Security

Jul 3, 2002

I've written code into excel that sends workbooks to email recipients. This works fine except for use on one friends computer. Of course it's the friend that needed the code in the first place.
What happens is that when the macro attempts to mail a spreadsheet an outlook popup occurrs warning that a macro is attempting to email a message. And so nothing gets emailed out!

View 9 Replies View Related

Macro To Compare Security Codes

Jul 18, 2008

I have 4 worksheets in a workbook: “choose security”, “download”, “MC” and “Lending”,

In the choose security” worksheet in CELL A2 is an HEX code, i.e. stock code.

2. In MC worksheet is raw data of all holdings related to various p’folios and securities, the information we need from this worksheet is,

a) p’folios, which are in column A,
b) Holdings which is Col B
c) Security code i.e. stock code which is in Col D

I need a macro or a formula to look at what security code is in “choose security” worksheet CELL A2, then look for this security in worksheet “MC” Col D, once matched, copy the data for this security to worksheet “download” and paste in CELL A3, I only need p’folios and holdings to be copied to “download” so data in Col A and B.

Once data has been copied to worksheet “download”, I then need another macro or formula to repeat step 2, but this time the macro will be looking at worksheet “Lending”,

a) P’folios, which are in Col B
b) Security code is in Col D
c) Holdings is in Col H

Once the macro or formula has found a match of security code, it will then copy the data from Col B and H to download worksheet CELL E3.

View 9 Replies View Related

Trusted Macro Regardless Of Security Setting

Oct 22, 2009

I've been told the latest Excels will allow any workbooks in a certain folder
to run macros as trusted (regardless of security setting?).

Can anyone confirm this please? Is there more to it? What versions are affected? Mine is 2003 so I can't check for this.

View 9 Replies View Related

Macro Security Changing Worksheet

May 13, 2006

I have created a workbook. That has 35 worksheets within it. I have created a series of buttons and put in a macro code so that when the user clicks on the button it changes the active worksheet to what they clicked on.

So basically when they click button b it changes to worksheet b and if they click button c it changes to worksheet c, ETC.

The problem I have is that since it is a macro it works fine on my computer but when it is sent to other users, because of security settings on their pcs it will disable the macro [thus the buttons will not work or show up]. I have created a digital trust certificate for it. However it is alot of steps to install this for the basic user. Is there a way to create a button that will do what I want without using a macro code. In that it will be able to go to many different users and wont have to worry about the buttons not working because of security settings?

View 9 Replies View Related

Macro To Change Security Settings

Aug 6, 2008

Is there anyway to change the security settings in Excel 2007 using VB macros? I have tried to record the macro as I change the settings but nothings is recorded.
Basically I have two workbooks, and I want to run one of the macros within workbook 1 from workbook 2. This is straight forward, however why I try to run it, excel says that the macros are disabled in the other workbook, but I know they are not, they are all enabled (bottom option)

I was hoping to find some way of fooling Excel into thinking the macros were enabled by changing the security settings (actually keeping them the same, but making excel think that i've changed them) before I try to the macro from the other sheet. I don't know if i've explained myself very well here, I hope I have, if not let me know and i'll try to go into more detail.

View 2 Replies View Related

Auto Run A Macro Even On Medium Security Setting

May 23, 2007

I have my Macro Security setting sets to 'Medium'. How can I auto launch my macro (ex. name - MyMacro) everytime I open the workbook ?

View 9 Replies View Related

Code To Edit Macro Security Settings

Apr 1, 2008

I need a code to change the Macro security settings of the computer where the file is opened to enable macros.

View 9 Replies View Related

Excel 2007 :: Any Way To Call Security Alert To Enable Macro

Jun 28, 2012

I'm trying to find out if there is a way to call the security alert to enable a macro. Let me explain...I was working on a sheet with a macro that I hadn't enabled yet. After working for awhile the option to enable it was gone and I found that I had to close the fine and re-open to enable the macro. I'm wondering if there is a ribbon or short cut icon to put in my access toolbar that will give me the option to enable/disable the macro. Seems strange that in 2003 I could to this, but in 2007 I have to close the file.

View 3 Replies View Related

Macro To Enable Macro Security

Dec 9, 2008

It's possible to add in my code a line that sets the macro security to low?

I have to put a excel file that contains macros in over 50 computers, and set the macro security to low.
It even exists something like this?

View 9 Replies View Related

VBA Security Options

Oct 12, 2009

We have developed an Excel workbook with hundreds of lines of VBA code written for a specific application, and we would like to protect it.

Could someone give me an idea of what security options we have over and above the below (if any)?

We have protected all sheets and the workbook itself with passwords. The VBA itself is protected with a passoword.

My understanding is that VBA can be hacked into quite easily.....is there any way of adding another layer of security/protection without having to move to another platform altogether?

View 6 Replies View Related

VBA Module Security

Dec 17, 2008

i am going to ask is for my curiosity only and to be sure that no one will break my password.
If the VBA module is locked for viewing and password protected, it can't be cracked??I asking this, because i made an excel application with macros, and i don't want the user of it to crack my password.
I have to mention that the password is 17 letter+spaces long.
I repeat again....i asked this ONLY for my application safety.

View 9 Replies View Related

Security Code Input

Dec 7, 2009

If I have a cell which has been validated and has a drop down list of 4 names in it.
I need it to prompt the user that when they choose there name and select, a window pop up or similar window appears asking for a 4 digit(or similar) code.

This is to stop others using peoples names against jobs they have completed so there is accountability if there are issues with information.

For each line I need it to re-prompt the user to enter the 4 digit pin so it cannot be tampered with.

Can anyone help with sending through a form and VB code possibly which I can copy into my spread sheet or a method I can use!

View 14 Replies View Related

Social Security Number

Sep 8, 2009

if there was a way to block out the last for digits of the social security number? list of numbers are in d4-d20

Ex

123-23-5785

would be

123-23-XXXX (with X's)

or how ever is supposed to be i forget the (standard) format

XXX-XX-5785

View 9 Replies View Related

Cell Value Security Check

Apr 10, 2007

There are 2 cells on my spreadsheet where individuals must populate $ values. I want to put a security feature in the worksheet that would create a pop up warning to the user that one cell must be greater than the other.

B26 (Client Assets) must be greater than B41 (Dollar Impact), otherwise a dialog box pops up to indicate to the user that B41 cannot be greater than
B26.

View 4 Replies View Related

Security Against Password Hacking

Dec 12, 2007

Is there a way to make excel less vunerable to hacking? We have a customer who is always breaking in and changing things.

View 4 Replies View Related

Security Warning (Macros Have Been Disabled)

Apr 28, 2008

I was playing around with Macros on an excel file. I created a few and ran them. In the end, I didn't like the way they ran, so I deleted them all. However since I ran them in the excel file, every time I open the file it gives me a warning saying
"Macros have been disabled."

Is there any way to remove the possible Macros ties/links from my file? I know I can disable the warning, but if I just want to remove the Macros ties to my file.

View 10 Replies View Related

Security - Protecting A Paticular Sheet Only

Jan 7, 2009

i have produced a spreedsheet on ms excel.

On sheet 2 is all of the information and tables etc.. for example prices and information for the combo boxes an such...i need to protect this sheet so no one can change anything on it

the problem is when i do so, and go back onto sheet 1 and say tick a checkbox or select something from the combo box is doesnt allow me to, the protection message comes up

i dont want this to come up on sheet 1, only on sheet 2!

i think its because i have links between the pages? like all of the info for the combo box is on sheet 2

View 9 Replies View Related

Security Warning When Workbook Opened

May 30, 2009

my workbook is finally working the way it should but every time i open it i get a security warning window with the options disable macros, enable macros and more info. how do i get this to not show up every time it's opened. this workbook will be used by someone other than me and i don't want them to need to do anything but open it and use it.

View 8 Replies View Related

Turn Off Security Warning Regarding Macros

Jun 2, 2009

I would like the security warning not to pop up when the workbook is opened. I have been able to turn it off for myself but I had someone else test it and each time it's opened the security warning pops up with the disable, enable messages. Is there a way to turn this off permanently so not matter who opens it it won't pop up?

View 9 Replies View Related

Macros Dont Work Even On Low Security

Aug 21, 2009

My dad wrote me a VB programme to save me time entering repetitive data into an excel template for my business. At first it didnt work untilll i reduced security to low. Sice then I fried my computer and have had to reformat it with a diffirent version of windows, vista service pack 3. Now even on low security it doesnt work.

The little button in the worksheet to make the macro happen isnt visible or doesnt exist.

View 13 Replies View Related

VBA To Determine If Federal ID Or Social Security #

Jan 29, 2010

What would be the simplest VBA to determine if a cell E7 contains:

A federal ID always 9 digits with only one hyphen which is always after the 1st two numbers. For example: 12-3456789

or

A social security number always 9 digits with only two hyphens which are always 1 hyphen after the 1st 3 numbers & the other hyphen after the next 2 numbers. For example 123-45-6789.

In other words,

If Range("E7") = a federal id then
or
If Range("E7") = a social security number then

View 10 Replies View Related

Sort Out All Bid Prices For A Specific Security

Jan 4, 2006

I have a security order list. This consist of several columns most important are

Column A Column B

Sec a 15,00
Sec b 14,50
Sec c 16,00
Sec a 15,10
Sec a 15,70
Sec b 16,70
Sec a 14,80

The first column gives the name of the security, the second column gives the bid price.

What I want is that I want to sort out all bid prices for a specific security. Vlookup works fine but again it just gives the first record. How can I get all bid prices for security a on a new worksheet without blank cells. If possible I would like to have it sorted as well.

View 11 Replies View Related

JOB SECURITY- How To Make A VBA Script Expire

Apr 20, 2007

method for making a VBA script expire?

I.e. it will only work for a specified time and requires the author of the script to renew it at a given point?

I want to be able to do this to strengthen my position as an independent contrator financially...and copy protect my work from unwanted exploitation

Some ideas:
1-MSG box requesting a pre-defined password to renew the time for the script to work along with contact info for the author

2-Ability to define # of days, months and or years the script will work

3-Ability to define the # of days, months and or years that a MSG box warning of pending expiration will appear

4Ability to define the # of days, months and or years that the renew will extend the use of the script with multiple pre-defined passwords allowing different lengths of time extention! Perhaps an encryption method allows you to in another excel sheet (say the comfort of your own home) generate at will a password that will extend a scripts life for 3 months?! They contact you again, and again you generate a "random" password that will extend the original script

5-Anti-hacking measures, using MS's built in security

This might be a useful way of extracting monies over time, for the use of a script you provide....pre-set

View 9 Replies View Related

Without Prompting For Any Macros Security Message

Aug 28, 2008

i want my application which i build though VBA in excel run on every computer without prompting for any Macros security message so is there any solution?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved