security

Hi, i am sure this is something simple. Could anyone tell me why this code isnt working please? Basically, i should lock the entire row IF the word "completed" is in column "O" Sub Lock_Completed() Application.ScreenUpdating = False With Sheets("AUDITS") .Unprotect "password"...

Hi all, I'm having a real issue in regards to being able to paste into a cell which supposedly has data validation on it. Basically I have a cell with a dropdown which gives one of 3 options. If you try and type manually into this cell it's fine it throws up the error saying you can't do...

I created a small Access 2003 DB for our office recently. Afterward my boss requested I make it password protected. I used the Security Wizard to establish a Full Permissions user name and a Read-Only Users username with different usernames and passwords. It seems to work fine. HOWEVER, now when...

A bit of a long shot, but I have a spreadsheet containing some fairly sensitive data, I want my colleagues to be able to access it freely but I need to ensure that it doesn't get copied or forwarded via email. Is there a way to prevent this from happening? Many thanks in advance.

Hello everyone, I've done some work and developed a spreadsheet using Excel and VBA, something I spent a lot of time on. I'm not overly concerned but would like to know methods and what I can do to protect this work. I know I can protect workbook/worksheets but is this enough? When I deliver...

I recently downloaded a finance application for Excel. It is amazing... I did not know Excel could do some of these things... For instance, it has an unlock key window that pops up when you first open it. i could not find a way around this (I bought the key for only $1 from them, so no big...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a very challenged audience who can't work Marco security.<o:p></o:p> <o:p></o:p> This is causing problems as I have hide/show filters, counts and other macros running on the WB...

I have an application that, if run on 2007, there is some kind of Security Alert message which has to do with Macros and/or ActiveX controls. Users must know how to activate these controls or the Macros will not work. Is there a way to avoid having manually 'Enable the Content' for Macros to...

Hi, I am developing a daily sheet report for my boss. In the sheets, users input their daily as well as the number of items they sell per day. I want to build the sheets so that once a user enters the data in one sheet and move to another sheet; the previous sheet should be locked and no data...

I am looking to build a macro to inform a user via a custom ribbon label or other similar process whether or not they have write permission to a network directory. This directory has only two secuity permissions: write access or no access or view. This spreadsheet is used to export transactions...

Hi All, Does anybody know if there is a way to prevent a user from navigating between worksheets by clicking the tabs at the bottom? I have a workbook that has "Next" and "Back" buttons to jump between worksheets, and I want to prevent users from being able to over ride it by clicking the tabs...

I am running Excel 2007 in Windows XP.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I would like to have an xlsx file with data and an xlsx file for the user that is linked to the data. What I need to happen for security reasons is that if...

Hi all, I have a macro with a lot of hotkeys that are set in the "WorkBook_Open" event code but many people get it and need to turn thier security settings down so they can run any macros. That is, none of the hotkeys will be set since that event code didn't run. Is there any method to...

I have a large workbook which is mostly protected so that users cannot change it. I have also disabled all of the save/exit options to keep them in my control. As a result I have had to create a number of small macros which allow me to unprotect everything/save the workbook etc. The problem is...

I was given the code below but I cannot make it work. Even I placed an x in the A1 cell of blankSheet, I can go to another sheet and make a minor change before blanksheet is again activated. I am using this as a form of protection for intruders. What am I missing? Could someone help me with this...

Hi There I made a copy of my database and ran the security wizard on the copy to create user groups and permissions. (to see how it worked) but when I re started none of the users or passwords are working and I am locked out. No problem I thought I will just delete the copy and try again, but...

Hello :) I have a few questions, I'm hoping someone can help. I have two workbooks, one (the master workbook) contains a several databases, the other (general workbook) contains worksheets designed to look up information in and add information to the databases using macros. Data is copied...