password on excel sheet

  1. M

    How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    Hi, I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information. How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...
  2. R

    The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization

    I can protect and unprotect sheet using VBA but I can't unprotect using the normal way of excel and I am providing the same password. any help please? below are the codes Sheets("sheet1").Select ActiveSheet.Unprotect Password = "protect20" Sheets("sheet1").Select ActiveSheet.protect...
  3. M

    Fixing an old spreadsheet (Remove Password & Fix Compile Error Message)

    Hello, I am trying to use an old spreadsheet that we used on an old job. It was made back in the early 2000s and now when I try to open it: 1. I get an error message "Compile error in hidden module: GlobalCode" whenever I try to perform any action. 2. I have long forgotten the password to...
  4. R

    VBScript to open a password protected file in order to edit links.

    I have a working program but want to add a password to the external file I'm using to update my active spreadsheet file. I do not want to be prompted for the password when I initiate the "update" command from within code. I would like to automatically pass the password through scripting. Here is...
  5. R

    Password Protect Macro From Running

    Hi, I know it's possible to password protect Macros from viewing / editing the code, but is it possible to password protect them from running? I've got two macros assigned to buttons, one to Protect all worksheets with a password, the other to unprotect them, with the password... But I'd like...
  6. U

    What is the trigger for password protecting a worksheet.

    I have worksheet one that I want to be read only for everyone but the second worksheet is superfluous I need to hide it. I password protect the first sheet everyday and I would like to know the code that will detect when the sheet is protected so it can hide the second sheet and when the first...

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