1. M

    Locking cells / rows after a specific date. VBA?

    dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...
  2. S

    Dynamic range with locked cells?

    I'm trying to create a user-friendly timesheet for someone who has never used Excel. How can I create a dynamic range linked to a pivot table with the formula cells locked? I can do dynamic or locked cells but not both. What am I doing wrong? And I'm VBA ignorant, can this be done manually...
  3. K

    Unprotect worksheet being asked when workbook is opened

    Hi, I have multiple sheets that are protected for using the standard Protect Sheet (select locked cells and select unlocked cells both ticked) but when the workbook is opened it prompts the user to provide the password to unprotect for as many instances that there are locked sheets in the...
  4. R

    Project locked???

    I created a file with VBA included. A buddy copied it to use on his network. He needed some fixes so I opened the file and the VBA developer but could not edit the code, it said that the project was locked and unviewable. I've never encountered this before...any idea what would cause this...
  5. 7

    VBA - really no solution for effectively debug locked code?

    Dear VBA experts and fans, I created an excel system that is full of VBA code and we give it to the client - with the code locked for viewing. Of course, there was soon a request that the client encountered an error, so I put "bookmarks" into the whole code - I divided the code into parts...
  6. P

    Code to unlock a locked spreadsheet without pw

    Hi guys, I have an xls that has been locked by a previous staff and both staff and password are gone... any vba code to unlock the thing?
  7. R

    =sum totals not adding up correctly

    Hello all, I have a spreadsheet that tracks flight hours and the totals aren't always adding up correctly. If starting total of hours in cell F15 is 5092.0 and this particular days trip was 1.4 total in cell F16, the new total is showing up as 5093.5 in cell F17. Cell F15 is a locked cell and...
  8. S

    How to disable macro recording at a workbook level

    Hi there, I'm working on developing a spreadsheet that locks down all data entered to text only - and contains no formulas, and will not allow recording of macros. So I locked down the format of the worksheets to text, and the structure of the spreadsheet to not add more worksheets, and...
  9. T

    VBA to Lock all Cells in all Worksheets

    Hi All I have an excel workbook with around 6 worksheets, when the final user presses a button I want all the cells in every workbook to be formatted to "Locked" and then every worksheet locked with a password. Basically once the final user signs it off the workbook can no longer be edited...
  10. L

    Limited to the amount of Locked Cells?

    Ive a workbook with several sheets and alot of locked cells in each but i seem to have hit a limit! the later sheets will not Lock the cells!? really?
  11. R

    Lock cells in each column after entered date has passed

    Please help address this issue: 1. All cells in worksheet 'Sheet1' are locked, except for cells C3:E12 (these are for manual entry) 2. Columns C, D & E have different dates displayed in row 2. 3. After this date has passed, rows 3:12 of that column need to be locked (no more entry allowed). 4...
  12. R

    Running VBA macro with SAP while windows user is locked

    Hello everyone, i really am struggling with this. I made a macro to run before i got to work while my windows user is locked. Altought, i noticed the code "selection.copy" is not copying anything because the user is locked, i don't know the reason, but when i run the macro with user unlocked it...
  13. Y

    Macro to unlock workbook for set amount of time

    I am new to this forum. I have been using it for research for a while but this is my first post. I have a excel test that we give to employees that should be completed in 30 minutes. I want to add a macro so that they can only have the time allotted to complete the test. It should do the...
  14. sparky2205

    Allowing functionality on locked spreadsheets

    Hi folks, I have some locked spreadsheets which the users want to be able to perform a spellcheck on. By default spellcheck is disabled when the worksheet is locked. As far as I can see the only method of enabling the spell check is by way of a macro. Am I missing something simple? I can't see...
  15. H

    Can't use PivotChart controls on a Protected Sheet

    Hi there, I have created a sheet with pivot charts that I want to be locked in place, but have their filter controls remain useable. When I protect the sheet though and check 'Use PivotTable & PivotChart', the pivot chart controls are locked. Can someone help? Pete
  16. B

    Hide/unhide columns of multiple sheets using tickbox - some locked cells

    Hello I hope you all can help. Sheet1 contains an activeX control (checkbox) which once ticked, columns H:M in all sheets sheet2, sheet3, sheet4, sheet5 will hide themselves (and when unticked, reveal themselves) The VBA used (from another thread) is: Sub ShowHideColumns() 'Assuming...
  17. G

    Error Handling in locked code

    I am creating workbook containing VBA procedures which will be distributed to many users on different sites. I have password protected the code to prevent people seeing/altering/stealing it but this is causing me problems supporting the workbook. I have covered foreseeable errors with...
  18. gheyman

    Access: Database Locked - Admin

    I created a database for me and others to use. But when others try to open it, they get a message that says its locked. What is this and how do I make this to where we all can use it?
  19. J

    Weighted avg

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  20. D

    formula to copy picture from one cell into another

    I've been using excel for about 20 years off and on and been a member to this site for over 10 years. I've also taken a couple classes but this has me stumped. I'm reaching out the the greatest excel minds on the internet. I have a spreadsheet with a picture in cell A1. This picture is...

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