protect code

Hello! I have prepared a document in which about 50 volunteers must indicate their availability on certain dates each month. The columns in which they indicate yes or no should always open for editing, for anyone. In contrast, columns A through L contain information they should never be able...

Hi Gurus, I have a macro (courtesy of the wonderful forum) within a workbook that is used once a month to clear out all the data from specific cells so we can set up a new empty workbook for the next month. The workbook contains several macros that users can and will use on a daily basis...

I am new to MrExcel and new to VBA and hope you will help me. I used the following code to protect my workbook sheets before close and upon save and it works great but I can't figure out how to write it to allow filters to still work on all tabs of the workbook when protected. There are...

Hello, I have a spreadsheet that is shared with people throughout the company, but what they can see and do with the spreadsheet is limited I have password protection on the VBA Project, the workbook, and all the sheets. I allow the users to interact with the spreadsheet through macros. When...

Hello, I have a document that has 100 sheets (all the same). Each of the sheets has cells that are protected and unprotected cells for folks to enter data. My questions. Is there a way to protect all of the sheets at once, instead of going to each one and protecting it individually. Thanks,

Apologies for raising this old chestnut but I have not been able to find a workable solution from any of the threads here. I have a protected sheet (no password) with a pivot table and some slicers on, along with some charts that I don't want messed up. I have unchecked the LOCKED properties...

Hello all, I have currently been implementing a VBA code allowing for the installation and VBA referencing of the "Solver". This code runs when the workbook is opened. This code is the only code I have in the "ThisWorkbook" object, but I have a lot of code connected to each specified sheet. In...