password protect

hi everyone, I'm creating a workbook, for all the manger in my company. they have to have access to their department's sheet + the summary sheet. So here is how I did. when closed the workbook automatically set the visibility of every sheet to xlVeryHidden. when open a user form is shown...

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...

Hi all, - I keep all my information in "document 1" (protected with password) - A second file "document 2" will be accessible for other people as well. In document 2, I have linked a column to a column in document 1 (a column that does not contain private information). Now, when the other...

Hi, I am trying to protect one of my workbooks having 7-8 sheets in it. When I password protect the workbook and open it again, the macros become disfunctional and my cells with VLOOKUP too dont work. How do I protect the workbook, but also be able to have functional macros and Vlookup. Your...

I am new to Exel and have been dropped in the deep end with my new job and although my learning curve has been steep there are a couple of things I urgently need to do and I am confused to hell! And I quite like my job so please can anyone help me!? I am working on a large work book about 20...

Situation: I have a spreadsheet for work with Salespeople and their A/R aging. I would like the salesperson to see the accounts pertaining to them and not others. This is needed as some salespeople are know to poach customers away from others. I don't want to filter the report and send...

I am trying to create an employee performance evaluation workbook in Excel. Here's what I have in mind: Each employee has an Excel workbook (e.g. Employee.xls); Each workbook has different tabs for different managers to access (e.g. Manager 1 and Manager 2); All managers enter scores for...

Can anyone recommend a third party app, or suggest a macro that can be used to force the user to always password protect (to open) a new workbook when it is saved. It's specefically for excel but would be nice if optional for word too? Also does this auto encrypt the workbook in excel 2010...

I am using Excel 2003. I have a workbook with about 20 sheets in it. 1. I would like the workbook to always open up with the first 2 sheets hidden. 2. I would like an administrator to be able to unhide those sheets, when prompted for a password to unhide. 3. After the administrator edits and...

Hello!! I am trying to password protect 2 worksheets using VB. I have started the coding but the forum box is not disappearing after the user inputs the correct or incorrect password. I hope you can help. I want the userforum box to appear as soon as the workbook is open. Here is what I...

I've been tasked with creating an Excel-based report that will be sent to a number of individual business partners, but rather than send a number of separate versions I'd instead like the data included within to be governed by a Username and Password login form. The form itself will only...

I have created a UserForm named Login_Pad with 2 UserBox's and 2 CommandButton's The First UserBox user labeled "User" the second UserBox is labeled "Password". The First CommandButton is labeled "OK" the second CommandButton is labeled "Cancel" The idea here is to show this UserForm using...

i have this code in my workbook that runs each time a user saves the workbook. problem is that i want to password protect the sheet and then return to the sheet the user was previously working in. so looking for 2 modifications to my code below: 1. to unprotect the sheet, then protect it when...

I'm really hoping someone can help me with this code! I've searched this forum and found some older posts about it but I still I can't get my coding to work!! There will be seven people using this workbook and they're each assigned their own tab to work with. I've got cells locked and each...

Hello I have a workbook (excel 2007) and would like to make sure that users need to enter a password when they open the file to be able to edit certain cells. Currently without a macro, if someone has the password, they can unlock the cells and edit the document, but if they forget to...

Hi, I am looking for a way to do the following automatically before my workbook closes: -Turn alerts off -Prompt for a password to protect the workbook -Save the workbook -Close the workbook -Turn alerts on I have tried a couple of different combinations and I cannot get it to work. It...

Hi guys, Quick one. Our Admin lady works with a password protected excel off a shared folder on another persons pc. (duh). She worked with an Excel document for the entire week. After saving it on friday, she walks in on Monday morning and it doesn't ask for a password nor does it contain...

Hi all, I'm new to this board so apologies if this is not clear. I have a macro that runs reports that are selected from a drop down filter. It then attaches itself to an email. However, I need to put a password on each report that is sent out. How can I go into the Visual Basic Editor...

I want to conver my xlsm files to xlam format i.e. created a excel add-in and wanted to hide the codes from user. First I tested the converted xlam without activating "password protect" or "select hide from view". It works fine.:) However, if I convert the same xlsm file to xlam format with...

Hello Everyone. I am using Excel 2007 and I cannot get my table to allow filtering when my worksheet is password protected. I recorded a macro to unprotect the worksheet, sort the table, then protect the worksheet again. My problem is that when I protect the sheet again, I lose the ability to...