protect /macros

Hi all I have the following macro in a module to protect/unprotect workbook...it's working fine but i have a few columns "grouped" so when i try to "ungroup" them, it says, sheet is protected. i have tried to define it in the macro so not sure what I am doing wrong. I am using Excel 2013...

HI, I was hoping someone might be able to help me. I'm looking for a macro that loops through workbooks saved in one folder and combine specific worksheets into one workbook (as separate tabs). The worksheets can either be called the same thing or be the 3rd, 4th and 5th worksheets in the...

Is there a way to prevent editing of a tab's contents if a specific condition is met? We have a budget workbook that contains a budget estimate tab that users should not be able to change after the budget is approved. There is a second tab for submitting a revised budget. So, the user needs to...

Hi, Could you please assist with below issue: I send out excel files to various branches within my company. I password protect the worksheets so that formula in certain cells can not be modified. I recently discovered that you can run a macro/vba code to unlock these sheets. How do I prevent...

I have a table which needs to be sorted/filtered and be able to have rows added to it, but the formulas need to be hidden and not editable. I have locked the sheet and right now am running a Protect or Unprotect sub every time one of my other macros is run (which is every time a new row is added...

Hi all! I'm having a hard time trying to create a password protected document in Excel that is robust to password recover programs like Passware. I would like to protect some cells and macros but Passware always finds the password in seconds when I use the Excel password protection system, and...

Hi everyone, I need to protect all worksheets within multiple workbooks. No password needed to open to workbook, but I would like a password to make any changes on the actual worksheets. There are over 2,000 workbooks with multiple worksheets that need to be protected. The workbooks are a mix...

Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...

Hey all, I think this should be pretty straight forward, but I'm struggling a little. (I'm still learning VBA.) I'm trying to protect a workbook, but leave a few ranges available for co-workers to edit. I have the ranges set up so I can go to: Review Ribbon: Changes Group: Allow Users to...

I need help with a macro so that simply typing in an X in a cell will password protect the entire spreadsheet. My boss wants me to have our purchase orders lockup once he puts in the PO information and puts his digital signature, he wants to type in an X in a cell and have the entire thing...

I have a worksheet in which a user selects from a drop down list and from there everything else is filled out. In order to protect this and prevent users from messing up the form (thus preventing numerous headaches for me), I want to lock all cells except for this one cell containing the drop...

A) I have this mini dashboard where I have to merge a few cells and wrap them. So I used one of the macro from this site to autohightadjust the merged and wrapped cells. B) Then I had to record another macro to run the above macro on a group of cells Then I created another macro to run B)...