protect code

  1. A

    How to password protect a MACRO and set a specific cell value

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

    VBA code to re-protect sheets of the workbook upon close and save that will also allow auto-filters to work

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

    Making my spreadsheets "Hack Proof"

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

    Protrcting multiple sheets at once

    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,
  5. M

    Protected sheet and pivot tables

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

    Protect only certain objects in a VBA code

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top