protection issue

Hi there, I have the below macro assigned to a Check Box on sheet "G2". The Check Box is Unlocked. I would like both sheets "Beef" and "G2" to be protected. However, the below macro will not run if sheet "G2" is protected (it runs fine with sheet "Beef" protected and sheet "G2" unprotected). I...

Good Afternoon, I am new on the forum and I didn't find the answer to my problem within the existing posts so I hope you will be able to help me. I created an excel document that includes over 200 sheets. The purpose is to have inputs from the production team on each sheet. The document is...

Hi guys, Long story short - bullied at work by both coworkers, boss, and HR. Would like your advice on ensuring the excel files I created are only able to be opened by me i.e. my physical presence. I also want my excel files to be hard to access when provided to someone else whether via email...

Hi there, Thanks in advance. I forget the password of my excel file which I used at my shop. Please I am in trouble and looking for someone to help. I last remember the password as "19791983", but its shows error. The file is available in the below link...

I have a macro that worked fine until I did some things to speed it up. Now I get an error message (after the macro finishes running) that says: THE CELL OR CHART YOU ARE TRYING TO CHANGE IS PROTECTED... If I click ok and look at my workbook, everything is perfect. Macro ran fine. There is no...

I have created some buttons in my excel sheet to highlight cells when clicked. However, I also want to protect the document so that only certain cells can be modified. When I protect the document the buttons no longer work even though the specified cells aren't locked. I'm sure it is just some...

2010 / w7 Next problem: I have User input sheet with ActiveX Control buttons and Form Controls. I had no problem adjusting the "protection" on the Form Controls but the ActiveX buttons are a different story. How do you set them up to protect the sheet but allow them to be "toggled"?

I'm having this issue with Workbook Protection killing my macros and i'm wondering if anyone else has had the same problem and if there was a simple solution. Here's the gist: I have a workbook that on one tab has a several lists that shows the offices and below each office is the list of...

I have a value in a hidden row that I now want to edit. I protected the workbook structure and the worksheet. No I find that even if I unprotect the workbook and the worksheet, I can't unhide the row! Can anyone tell me what is going on here?

Hello, I have created a workbook with multiple tab containing multiple formulas wich are all brought to a cumulative tab. If any rows or colums are added, the user will not be able to find why the cumulative is not showing the right numbers but the formulas won't adjust correctly. 1. I tried...

Hi, how safe is it to sell our project in excel format excel protected sheet can be cracked down and anyone can recover the password and see the code or formula. like given in the below link {moderator edit: link removed} How can we protect it in such a away so that nobody can crack it...

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

Hello There, I have designed a spreadsheet which is nearly ready to be deployed nationally. However I wish to protect the code etc in the spreadsheet but I have a few problems I need to get around. The spreadsheet is designed so a user places a number in cell A5, in turn this number is...

I set up a security measure (to keep me from doing something stupid on a spreadsheet), now every time i open the spreadsheet, i have to type in the password. I know that password, that's not the problem. I want to take the password completely off, its too much of a hassle and others can't open...

I have a workbook that is used to create client quotes. Two of the sheets have macros within them 1. Macro in QUOTE sheet hides/unhides rows based on result in column A. It is triggered by a control button. It unprotects the sheet when the control button is clicked and then protects it again...