password protect

  1. csababenyi

    Insert data with VBA command button into password protected sheet

    Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...
  2. D

    Password protect or prohibit the "Save" & "Save as" option in Excel

    Hello everybody, I am currently managing an order form in Excel, where people download it and then they go in every day, fill out the details and submit the order through a macro. They will just need to download it once and then do this whenever they have an order. However, is there any way in...
  3. K

    Very Hidden Password Protect Worksheets

    To start, I have no idea how to write or run macros. I know that I want to have 37 of the 39 sheets in a file I made to be VeryHidden so they are as protected as possible when the workbook is opened, with a prompt to enter a password to reveal the sheets. I've seen macros that I guess have...
  4. S

    Showing *** rather then characters when entering password

    Hi All, I use some code which I found here to unhide and unhide tabs which also requires a password, however I was wondering is there any way that when I enter the password it just shows up as ********** as it would in normal scenarios where you have a password as the below allows the letters...
  5. 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...
  6. J

    Password Protect a Macro Button

    I am working on a spreadsheet of a staff schedule and I want to add macros so that each staff can only see their shifts and have a RESET button to see the entire schedule. However, I do not want all the staff to see all the schedule. Is is possible to put a password on the RESET button so that...
  7. L

    Lock and Hide a Cell

    Hi! I have a cell (J2) and I only want people with a password to be able to unhide and edit this cell. I can't seem to figure out a way without having to "protect", "unprotect" (to make edits) and "re-protect" again. Does anyone have any recommendations or advice on how to best achieve this...
  8. tlc53

    Password Protect Checkbox

    Hi, I have looked into this for quite sometime but I haven't been able to get anything to work. Can someone help me please? I currently have a check box which when ticked, returns the date in the same cell (Q7). However, I want to restrict who can check/uncheck this box with a password...
  9. T

    Password Protect PDF from Excel

    Hi! I want to know if it is possible to password protect a pdf after converting from Excel based on the output of a cell. For example, cell B3 (with formula) is equal to Bar732, this value would be the password of the converted pdf. Right now i have the code below: Sub PDFActiveSheet()...
  10. J

    Password Protected Sheets should be hidden until after password is enterred

    Hey there, I'm hoping for some help with my VBA code in Excel 2016. First, I know that this is not fool-proof security, but that's fine for what I'm working with. I have an excel workbook, with many hidden sheets (one for each employee), and a menu tab with buttons linking to each sheet. I have...
  11. 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...
  12. V

    Password Protection Multiple Workbooks & sheets

    Hi, I Need help in to protecting sheets in multiple workbooks in a particular folder. With a particular password 1st i would like to protect sheets from editing in multiple work books in a folder. I also need to provide a different password to open that work book. It's like with a password...
  13. G

    VBA Issue with Worksheet Protection Passwords

    Hi all, I'm new to the forum although have been helped by it on many occasions. I have come across a problem while trying to use VBA to protect my worksheet and was wondering if anyone else has had a similar issue. Essentially I am adding two levels of protection; one level for the end user of...
  14. C

    Macro Question

    Hi all! I have a question regarding Macros. I have a spreadsheet that I am working on for work and want to insert a button, "Lock" and another, "Unlock" When pressing the Lock button, I want for the entire spreadsheet to be protected. When pressing the Unlock button, I want for a window to...
  15. T

    BeforeClose not running

    Good afternoon All, My first post to MrExcel B) I want a macro that password protects all sheets in the workbook called 'Potato' when the workbook is closed. For some reason it doesn't work and I can't figure our why :s Can anyone help me? This is what I've written: Option Explicit Sub...
  16. D

    Macro for protecting all the worksheets with password

    Hello, I have about over 200 xls files and was asked to protect all the worksheets with password from being able to edit and print. Is there a macro available to protect them by batch? In need of help. Thank You.
  17. S

    How do I use a macro to put a password on an exel file with excel 2010

    Hi All . I previously used the following macro to put a password on all excel files within the specified network directory. Now that I have moved over to excel 2010 this macro no longer works on either xls or xlsm files. Any help would be appreciated. I previously use the following macro to...
  18. L

    UserInterfaceOnly - protection not recognised?

    Hi All I allway write all my code in lowercase, so that when it capitalises I know I have spelt it correctly. However I have been looking for a better way to protect my workbook to avoid the endless looping. And found the UserInterfaceOnly property which seems to state it will allow VBA even...
  19. D

    Password protecting different pricing for different users

    Folks, I have a spreadsheet with lots of parts and quantities that I'd like to discuss with two different parties (A and B), however I have two different pricing with both parties. I'd like to be able to chat with both of them at the same time to work toward the right quantities, but I'd...
  20. S

    Secured workbook

    hi everyone, I'm creating a workbook, for all the manger in my company. they have to have access to their department's sheet + the summary sheet. So here is how I did. when closed the workbook automatically set the visibility of every sheet to xlVeryHidden. when open a user form is shown...

Watch MrExcel Video

This Week's Hot Topics

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
Top