lock sheet

  1. Pinaceous

    VBA If thismonth then lock sheet# criteria

    Hi All, I'm working with a workbook where it opens up to a specific sheet# based upon the current month. For example, if it is: October it opens up to Sheet1 . . . September it opens up to Sheet 12 in using this code: Sub MonthSheetSelect() Dim shtname As String Dim thismonth As Long...
  2. D

    lock sheet 3 days before particular date allow certain user only to edit

    hi, i have a excel sheet of daily load list on network drive where every body can add and edit what they want to load for particular date, i want to lock the sheet 3 days before the actual date of loading. for eg i have 31 sheets for month of jan. on all sheet date of loading is typed and...
  3. J

    Locking down a sheet but allowing cell updates

    Hi, Is there a way of locking a sheet so the data cannot be manually changed, but can be updated from another source? I have 2 sheets (A and B). Sheet A is where the person inputs what they want. Sheet B is all these formulas checking if the information in A is correct and notifying if...

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