security

I am looking to create a log-in screen for staff to enter their Username and Password to access a certain form. Their log-in details are saved in a table called tbl_Staff_Name (Column 7 = Username, Column 8 = Password) When they log-in i want them to be able to access the form Splashpage Does...

Hello everyone, does anyone know if there is a way in excel 2007 that I can remove the ability of users to get into the VBA module? I would like to create a macros and be the only one to enter in the VBA for that specific workbook. no other users should be able to input new modules to my...

Hello there fellow Excel Geeks!! Im trying to create a sort of security profile to allow 3 different types of users different types of access to a very confidential workbook. 1) Admin to be no holds barred, full rwx 2) Business Users should only be allowed to have read only (r--) to all...

Good Morning/Afternoon All This is my first post, My name is Jorge, but call me George, I work as a Controls Engineer at an Automotive Parts Supplier in Mexico. Straight to the point. I have a heavily scripted Excel File that serves as a Database for a client, i would like to ask somebody...

Hello All, I have a tricky situation. I hope there is a solution for it. Otherwise I will have to rework my workbook. I have a worksheet that has public information in columns A through R. It has confidential information in columns S through AD. I need to share this spreadsheet on a...

I have a workbook with ActiveX controls that works fine. There is a Workbook_Open code in ThisWorkbook. The problem is when another user opens the workbook for the first time. The user receives the security message for enabling ActiveX controls but, at the same time, the Workbook_Open routine...

Good Morning Guys, I was just wondering if anyone knew of some code that I could enter into my workbook that would stop modifications from happening to anything other than 2 cells that are used for searching data? Many thanks bloodmilksky ^_^

I know how to protect a workbook in excel. My question is can I have a standard set of passwords that I can setup and then quickly choose a password for a workbook? I have 20+ customers and I want to password protect excel workbooks using a different password for each customer. The excel files...

Here it the thing. I have workbook that connected to SharePoint lists and file and intended to end-user. Data flow from SP goes to hidden sheets (very hidden via VBA). Then kicks in some modeling and transformation and data loaded to Data Model (Pivot table) only clean and what allowed to see...

Hi, I designed a macro where once the user double clicks the file, a userform is displayed. Based on the option selected it will display other forms. When the user opens the form for the first time, it displays the Security Warning and after clicking on "Enable Content" the userform is...

Hi all, I've got various bits of code which refer directly to the password currently used to lock excel sheets. The code works fine, however, this causes a couple of issues. Firstly, the code is not dynamic, and won't function correctly if the password has been changed and secondly, if someone...

To give you a bit of background - part of my job is to create 300+ workbooks to be sent out to Companies to be completed and returned. From this I then create VBA coding to pull them into one master document. The documents themselves are created very simply, using a hidden tab containing the...

We are investigating PowerPivot on SharePoint to make a dashboard. -Management needs to see all teams and granular detail. -Each team needs to see its own data only, and only at high to medium level. What option are available? I see that SharePoint has file level restriction only. Does this...

Excel 2010 Win7 Ult. SP1 Greetings to all, I've been working on dashboards, using embedded charts - mostly bar charts. I've incorporated drill-downs such that, when a user clicks on a bar in Chart1, Chart2 responds. And when they click on a bar in Chart2, Chart3 responds. Again, these are...

Hello, I am working with some sensitive data and find myself in a need to monitor access to the MS Excel/Access files we use. I need an effective solution. I was thinking about macro which would send me a message or would connect to certain address to leave a log with the computers where it...

Hi there, My macro uses a function in an external DLL declared on top like: Declare Function Calculate Lib "CalculationsLib.dll" (ByVal param1 As Integer, ByVal param2 As String...) The DLL library is in the same path as the excel document. Then the instruction in the macro is like: result =...

Hi, I'm a newb to the forum an have searched past threads on Excel security and have come to the conclusion that no protection will provide absolute protection. Can the forum recommend the best course of action though for an Excel sheet that will be read only but has to run some VB code in the...

Does anyone know how to get rid of the warning that comes with Macros? It is something to the effect of a warning of potential hazards of opening a document with Macros. A lot of the spreadsheets I work on I need to distribute and people get scared of opening or changing settings in excel when...

I have an excel which contains classified information. It does not contain any macro. I have put in workbook level security so employees cannot check the 'veryHiddenSheets'. I am ok with employees copying the data etc, but I don't want anybody outside the organization opening it. The excel...

I am trying to get all entries in Column D of a single worksheet to capitalize. I am trying this code in the "ThisWorkbook" area of the spreadsheet. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Target.Column = 4 Then Target = UCase(Target) End Sub Yet, when I...