Security Against Password Hacking
Dec 12, 2007Is 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
ADVERTISEMENT
Macro Security (saying That The Macro Security Level Is Too High)
Nov 18, 2008I 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.
Password Protection :: Asking For Password Of An Old Deleted File
May 27, 2009When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.
View 11 Replies View RelatedForgotten Password For Password Protected Sheet
Mar 21, 2007I have a spreadsheet, which has certain worksheets that are password protected. I need to make changes to some of the formulas, and the VBA modules, however I cannot remember the password!! Is there a way of identifying the password??
View 3 Replies View RelatedMacro - Paste Password Into Password Box
Nov 28, 2008I am havng problems with the belwo macro code -
Range("G7").Select
Selection.Copy
Workbooks.Open Filename:= _
"Q:PublicPAYMENTS Q&RREPORTSSuspense Activity BUSINESS2008 - Suspense BUSINESS - Activity Reports2008 Avon.xls"
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
When i open the workbook it requires me to insert a password, i tried to type this but excel will not follow keystrokes, i then inserted the password in cell G7 which i then copy and paste, which you can see the copy at the beginning of the macro.
Is there a way where you can get it to insert the password so i can open the workbook in a macro.
What im trying to do is save 26 suspense spreadsheets by just clicking on a macro.
Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?
Jan 12, 2007I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub
Are You Sure - Security For Macro
Aug 7, 2007I 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.
VBA Security Options
Oct 12, 2009We 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?
VBA Module Security
Dec 17, 2008i 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.
Macro Security
Jun 29, 2006If 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 RelatedSecurity Code Input
Dec 7, 2009If 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!
Social Security Number
Sep 8, 2009if 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
Cell Value Security Check
Apr 10, 2007There 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.
Security Warning (Macros Have Been Disabled)
Apr 28, 2008I 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.
Security - Protecting A Paticular Sheet Only
Jan 7, 2009i 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
Security Warning When Workbook Opened
May 30, 2009my 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 RelatedTurn Off Security Warning Regarding Macros
Jun 2, 2009I 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 RelatedMacros Dont Work Even On Low Security
Aug 21, 2009My 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.
VBA To Determine If Federal ID Or Social Security #
Jan 29, 2010What 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
Sort Out All Bid Prices For A Specific Security
Jan 4, 2006I 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.
Xl Macro Cant Email Due To Outlook Security
Jul 3, 2002I'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!
JOB SECURITY- How To Make A VBA Script Expire
Apr 20, 2007method 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
Macro To Compare Security Codes
Jul 18, 2008I 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.
Without Prompting For Any Macros Security Message
Aug 28, 2008i 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 RelatedActive Workbook Refreshall Security
Nov 4, 2008I have a function that is called in Access vba code that refreshes all sheets in a given workbook. We use it all the time for workbooks containing any number of tabs to be refreshed. The code has a key line: ActiveWroksheet.Refreshall. I need to now start to secure the pivot so the user can not refresh it. Another post pointed me towards: .PivotCache.EnableRefresh = False.
This apparently can only be used for a particular sheet; ie it can not be applied to ALL sheets in the workbook. The trouble is the function is generically used to refresh any workbook, and the number of sheets may vary.
Any thoughts on how I can disable the ability to refresh a pivot for ALL sheets. I'd prefer not to turn off the pivot wizard since the user should be allowed to manipulate it...just not refresh it.
Security In Table/list Database
Jan 28, 2009Is there any lock/security option in excel sheets, suppose we make some table/list and after entering one data when the cursor goes to second raw, the previous raw data automatically lock. the user cannot edit or delete that record.
View 10 Replies View RelatedTrusted Macro Regardless Of Security Setting
Oct 22, 2009I'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.
Macro Security Changing Worksheet
May 13, 2006I 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?
Dialog Constant For The Security Form
Jul 23, 2006I have some code that requires access to the Visual Basic Project. If the user hasn't checked this option in Excel, I'd ideally like to open up the security form for them, with code like the below:
Application.Dialogs(xlDialogOpen).Show
However, I can't find the dialog constant for the security form. Does anyone know it, or have any alternatives? I don't want to use SendKeys.
Vsto .net Security Policy Not Permitted
Nov 29, 2006I am using Visual Studio 2005 Profesional with VSTO, making a program for Excel Office 11. My code is working when inside the Studio. But when building the code, and then trying to run the xls file direktly I get the error attached. I need information about what I am doing wrong, and how I can change the .NET security policy so that the code will also run outside the Studio.
Could Not load file Or assembly 'TestExcel, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)............................