unlocking

  1. V

    Unlocking a chart/graph

    Hi guys After searching an hour for the correct code. I am creating a new shape with this code: Sheets("processtyring").Unprotect Password:="HKV" ActiveSheet.Shapes.AddChart(xlBarStacked, 150, 150, 1000, 250).Select Sheets("processtyring").Protect Password:="HKV" Now i...
  2. D

    cell location is locked cannot format it

    Hi Everyone, Someone got into my spreadsheet and locked a cell so I cannot format it. How can I find out how they did it and how can I unlock it? cell G1 has the date January 1,2017 in cell G2 I have (=G1) and custom formatted to "d" to show the day only but it shows January 1,2017. No...
  3. C

    Help on Macros Unlocking Selected Locked Cells

    Hi! I would like to seek some help on macros unlocking selected locked cells using macro. By default, all cells in my worksheet are protected/locked because, I would like my colleague to use the macro feature of my file. But the problem is, I do not have any background on macros. Can anybody...

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