protect /macros

  1. B

    VBA Code to Protect/Un-Protect Sheets asking for a password when there isn't one

    Hello Everyone, I wrote some code to protect/unprotect all of the worksheets in my workbook, and when I run the code in the vba editor it works perfectly fine. However, I added some shapes to my excel file and then assign the macros to those shapes, so the macro could be run at the click of a...
  2. N

    Macro to hide/unhide columns in multiple worksheets and protect/hide on close

    Hello I have limited knowledge with macros so would appreciate any advice you can give me. I have a Workbook that has several users - most only need to view the Workbook, others need to edit certain columns. I would the columns that need to be edited hidden on opening and only visible once...
  3. A

    Allow using Named Ranges of protected sheet as data source in pivot

    Hi Friends , I am using named ranges as data source in pivot. These named ranges can be selected by user from a combobox. I change data source of the pivot on the basis of named range selected from combobox. My code works fine if the sheet of the selected name range in combobox is unprotected...
  4. C

    Allowing Double Click to run code in protected sheet

    I've got a dilemma I am faced with. I have a sheet that has GETPIVOTDATA formulas that I have created a BeforeDoubleClick Event that opens a new sheet containing the data reflected in the GETPIVOTDATA via VBA code. It works without issues when I click the options to allow selection of locked...
  5. V

    Need cells to lock until a comment is added in the comment cell then unprotect sheet

    I am new to visual basic and need some help with some coding. I have a excel template that has an plan end date and actual end date (2 separate columns) if my actual end date is greater then my plan end date, I need a message box to explain they need to write a comment. If there is no comment...
  6. J

    VBA to copy current sheet (template) and make one sheet for each day of the month and protect it

    Hi, The title says it all. This is similar to my previous thread, but I would like to protect the sheet when its created from the template. I wont be using the sheet more than once a day. I also would like to carry over the closing balance of the items in the newest sheet, to the opening...
  7. D

    Making my spreadsheets "Hack Proof"

    Hello, I have a spreadsheet that is shared with people throughout the company, but what they can see and do with the spreadsheet is limited I have password protection on the VBA Project, the workbook, and all the sheets. I allow the users to interact with the spreadsheet through macros. When...
  8. E

    Need help to lock/unlock multiple sections of a worksheet as when clicked by user

    Hi guys, I am an excel savvy person, but not too expert like VBA or macro programmers. As such, I need some help on figuring out how to lock certain portions of my worksheet upon a click of a button. Imagine a 30-day calendar spread page. I need to have 30 buttons which will enable the user...
  9. M

    VBA to prompt when clicked on protected cell

    I have Workbook with both Sheet/workbook is protected. I have a code to lock/disable certain range of cells when the drop-down value "no" And unlock/enable when value of drop down is "yes" Whereas, drop-down value and cells I would like to disable are on different sheets. Dropdown on "Main...
  10. 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...
  11. C

    Protect and Unprotect Specific Worksheets

    Hello All, I would like a Macro/s that is/are able to protect and unprotect specific worksheets. This is so that other Macros can then access the data on these sheets. Currently I have a Macro, taken from another thread, that Protects and Unprotects all of the worksheets. This works fine...
  12. P

    Hiding/Protecting Specific Code in VBAProject

    Hey team -- Long time fan of Mr. Excel, but this is my first post and I hope that you can help me out! The code written helps me to determine if my students are sharing excel templates in order to submit less-than-honorably-produced assignments. I created some code to automatically log the...
  13. B

    protect/unprotect workbook macro

    Hi all I have the following macro in a module to protect/unprotect workbook...it's working fine but i have a few columns "grouped" so when i try to "ungroup" them, it says, sheet is protected. i have tried to define it in the macro so not sure what I am doing wrong. I am using Excel 2013...
  14. C

    Macro to combine password protected worksheets from separate closed workbooks into one workbook

    HI, I was hoping someone might be able to help me. I'm looking for a macro that loops through workbooks saved in one folder and combine specific worksheets into one workbook (as separate tabs). The worksheets can either be called the same thing or be the 3rd, 4th and 5th worksheets in the...
  15. N

    Prevent Editing of Tab Contents if Criteria Met

    Is there a way to prevent editing of a tab's contents if a specific condition is met? We have a budget workbook that contains a budget estimate tab that users should not be able to change after the budget is approved. There is a second tab for submitting a revised budget. So, the user needs to...
  16. Z

    Protection of all VBA in one

    Hi, Could you please assist with below issue: I send out excel files to various branches within my company. I password protect the worksheets so that formula in certain cells can not be modified. I recently discovered that you can run a macro/vba code to unlock these sheets. How do I prevent...
  17. X

    Best VBA Alternative to Locking a Worksheet?

    I have a table which needs to be sorted/filtered and be able to have rows added to it, but the formulas need to be hidden and not editable. I have locked the sheet and right now am running a Protect or Unprotect sub every time one of my other macros is run (which is every time a new row is added...
  18. A

    Effectively password protect a Workbook and Macros

    Hi all! I'm having a hard time trying to create a password protected document in Excel that is robust to password recover programs like Passware. I would like to protect some cells and macros but Passware always finds the password in seconds when I use the Excel password protection system, and...
  19. D

    Protect multiple worksheets VBA

    Hi everyone, I need to protect all worksheets within multiple workbooks. No password needed to open to workbook, but I would like a password to make any changes on the actual worksheets. There are over 2,000 workbooks with multiple worksheets that need to be protected. The workbooks are a mix...
  20. D

    VBA not functioning completely - protect sheets and workbooks

    Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...

Some videos you may like

This Week's Hot Topics

Top