protected sheets

Hi - I have a file that needs to be protected on multiple sheets but still allows for collapsing/uncollapsing grouped, filtering, inserting comments, formatting, etc. I have 2 sets of code that almost work, but one does everything except the grouping and the other does everything except the...

I have a workbook with multiple sheets that I need to be able to share with someone who will take over doing the results, but I am faced with a dilemma and hope there is a solution. So each sheet has 27 columns of data which are able to be edited and there are new selections added daily. The 25...

Hello, My question is: I have protected worksheets that I want to allow any end user to format the column width and the row height. I also want to allow any end user to group and ungroup existing grouped columns/rows. I have a VBA for the grouping issue - Private Sub Workbook_Open() With...

I have sheet-a, it contains pivots only, only allows select locked/unlocked/autofilter, and sheet-b, it contains pivot chart, only allows select locked/unlocked/use pivot table & report, sheet-c contains both pivot and report, only allows select locked/unlocked/use pivot table & report, some...

Greetings. I have a schedule tool created and struggling to find the right code. We have a sheet named "Associates" and will have a button on this sheet to link a macro module to update a number of other sheets. There are 7 protected sheets, let's just say "Sheet 1", "Sheet 2", "Sheet 3" etc...

Hello! I have a model that has two macros in it that both basically copy and paste data. How can I get these to run but also protect the sheets so that no one accidentally makes changes to these (they should be making changes in the master sheets and using the macros to copy the data)... My...

I have an excel model built in windows with data validation lists/dropdowns. The file is locked with a password. MacBook users can’t see anything in the dropdown? If the file is unlocked the dropdowns work but not when locked? Any help, please? Thanks in advance.

I've been scouring the message boards for a solution, tried combining codes to achieve what I want but nothing seems to work. I want users to be able to access a protected excel sheet form held on a local network drive. They need to be able to complete their details, then send it to a person...

Hey there, I'm hoping for some help with my VBA code in Excel 2016. First, I know that this is not fool-proof security, but that's fine for what I'm working with. I have an excel workbook, with many hidden sheets (one for each employee), and a menu tab with buttons linking to each sheet. I have...

Hello, I have a protected sheet with a bunch of data. I want to allow users to be able to change values in a single cell only while still retaining most of the protected sheet rules such as not being able to format or delete the cell, adding/editing comments, etc. My idea is that once the...

Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...

Hi guys, I'm at a loss as to why my Active X Combobox won't work even after unlocking all the cells the combobox is referencing and inserting unprotect and protect code in VBA editor. Here is the code: Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, _ Cancel As Boolean)...

Hi Guys, I'm seeking some assistance in trying to merge several sheets in a workbook. The problem i'm experiencing is that because the workbook is shared and protected, I do not have the ability to utilize VBA. I also tried to use the add on Kutools. Not sure if you have heard of it, but...

I'm working on a Template that will be Themed buy a few members on a monthly basis. All the Sheets are protected and the user is to basically just Background Fill the Cells, etc. All Sheets are to be Themed Identically. But to avoid doing the same thing on each Sheet, they group the sheets...