protect sheets

  1. H

    Auto-Protrect Sheets in Shared Workbook?

    Hello all! Is it possible to have a workbook auto-protect the sheets, even as a live (auto-save) file on Sharepoint? Before uploading this shared workbook to Sharepoint, we had macros set to automatically re-protect all sheets in the workbook. I'm having trouble working out if this function is...
  2. tlc53

    VBA Code Amend - Protect All Worksheets, Allow Formatting of Columns & Rows

    Hi, I found this neat VBA code to protect / unprotect all worksheets without having to do each one manually. See below. The only problem is, it only allows; - Select Locked Cells - Select Unlocked Cells Whereas I want another 2 options to be included as well; - Format columns - Format rows Does...
    • tlc53
    • Thread
    • protect sheets step vba & excel 2010 worksheet worksheets
    • Replies: 3
    • Forum: Excel Questions
  3. R

    Hide sheets, protect all sheets and workbook structure when closing

    Hi all I'm having a problem, and after many hours searching for a solution, i desidet to ask in here. What im looking for is a macro which does: When i close my workbook it should password protect some specific sheets, the workbook structure and then hide some of the sheets. I simply can't...
    • Rasmusjc
    • Thread
    • hide sheets excel vba password protect protect sheets protect workbook sheets
    • Replies: 5
    • Forum: Excel Questions
  4. N

    Protect Worksheet with UserInterfaceOnly still stopping code.

    Hello, On my sheet I have tables I want users to be able to add / remove / edit data through a form, but have them protected from manual manipulation. After running Worksheets().Protect, UserInterfaceOnly:=True on Workbook_open() it allows my code to edit and remove items, but not add. The...
    • NickT33
    • Thread
    • add error protect sheets remove userinterfaceonly
    • Replies: 11
    • Forum: Excel Questions

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