locked

  1. 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...
  2. 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...
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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?
  9. 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...
  10. 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...
  11. 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...
  12. S

    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...
  13. 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
  14. 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...
  15. 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...
  16. 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?
  17. 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/>...
  18. 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...
  19. C

    Macropod

    you locked my original thread didnt know how else to get a hold of you
  20. S

    Sheet Protection

    Hi there, I'm trying to put a code into my macro, but I struggle with finding right arguments for the code. I'm want cells from A:F to be locked and be unselectable, and range from H:Q to be locked and selectable. Any ideas? Thanks

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top