protect code

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