protect buttons

  1. M

    Macro to protect a workbook with password protected sheets

    Hi, I have a workbook that acts as a sort of questionaire. Each day, employees fill in the data for the day (batch numbers, dates, times of work, ect) Most cells are locked and protected apart from the answer cells. This is all on 3 sheets (all protected). I want to run a macro that can be...
  2. W

    Lock Button but auto on close

    Good Morning, I have put a lock button in to my Excel workbook to lock all sheets when I press the button. As a stupid person I keep forgetting sometimes to press it to lock the sheet so I am looking to automate it so that if it hasn't been pressed when before I close it then it locks itself...
  3. A

    Unable to protect Buttons (Not Active X)

    Hi, I have been trying to protect these buttons that are not active x without any success. I have protected the whole sheet and checked all the boxes and that still does not work. Everything gets protected in the sheet other than these 8 buttons. One can still right click and delete or move...

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
Back
Top