locked

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...

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...

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...

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...

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...

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?

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...

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...

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...

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?

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...

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...

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...

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...

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

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...

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...

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?

<!--[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/>...

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...