locked

Having time value problems and it is throwing our time off by 6 minutes or more. Someone posted on a previous thread of mine and asked for the formulas I had. Unfortunately, I got locked out. If you would please reply or anyone reply I would appreciate it. I have the formulas that are coming...

Good day, created a fine looking spread sheet loaded with functionality ... one of them being some command buttons which reveal some hidden rows upon each "click" ... locked all the cells I didn't want people to mess around with and protected the sheet ... in "protected sheet" mode the button...

Excel Friends, I found this proven code to Unlock only Empty Cells. I tested in my active sheet that has many vertical and horizontal merged cells. it works for regular cells, but the merged ones are kept unprotected. Can somebody fix it? I appreciate any help. Thanks! Sub...

I am having trouble with Excel 2010 addin Microsoft Datepicker. Much has been written but cannot find my answers. It looks like it is impossible to feed it a null date. I would like it to start blank. 2nd Question. I have 2 datepickers on one sheet. I would like one of them locked so it is...

Hello All, I want to stop excel from showing MsgBox when I double click on locked cells. Thanks in advance. Kelly

Hey guys, So I know that this has been a previous post, but most of the issues have revolved around the excel file being shared or having a digital signature. I am unable to view the VBA code, and my excel file is neither signed nor shared. Additionally, I'm 95% sure that it was created in one...

Sir, I had prepared a table in excel sheet (in excel 2016) for data collection. I had locked the heading cells and unlocked all other cells in the table. Then I had password protected the sheet. When I sent it to others, some of them copied data from their word file (word 2007 and...

Hello, I'm trying to figure out the VBA code to sum a certain cell on multiple sheets. I've made a workbook to keep track of revenue for my job. I made a locked sheet where my team can enter the necessary information and then I added a button that will save this information onto a new tab and...

I am having an issue with my sheets being locked and using a MACRO transition code to hide and unhide rows by clicking on a circle shape . My Transition code hides and unhides rows 16-17. I would like to still hide and unhide these rows even if the sheet is locked. But currently when i lock it...

Hi, is there a way to insert an image to every sheet in a workbook, have it appear on the screen as you scroll down/across? I would also like to lock the image, so no one can delete it - perhaps a password protected macro? If I can't do the first, what's the best way to tackle the password...

Hi Friends, Hv a workbook with multiple sheets (months). In july sheet I need these feature: July <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col...

I have a worksheet that has some locked and unlocked cell, and the worksheet is protected with a password that only I know. When the user closes/saves the document, I want to prompt if they want to save the file as an "Internal Use Only" file that preserves the status of the locked/unlocked...

Hey gang, So I've noticed that I am evidently doing something incorrectly when I am invoking a particular bit of VBA code within a source.XLSM file. Here's my program file flow. script.BAT calls script.VBS which calls "ProcessCVS" subroutine within script.XLSM. Here are the pertinent...

I need to vlookup a date from a downloaded spreadsheet to my spreadsheet. It’s in yyyy-mm-dd format and will not change. Somehow, it’s locked. Usually, I’m able to vlookup it, and then text-to-columns and concatenate to change the format. But now, for some unknown reason, the vlookup will not...

Hello everyone. I did an internet search and a search on this site before posting this. I couldn't find an answer to my question. I may not have been putting in the correct criteria, though. I have a userform that is pulling information from a spreadsheet. It's for viewing a products...

I am a total rookie and trying to solve an issue on a spreadsheet we use. The initial issue was when I had the column locked the sorting wasn't working properly. I tried a few methods that I found and had the best result by forcing anything entered into the column to be undone. The column has a...

I have a worksheet that is protected and users can only tab through and select unlocked cells. I am aware I can make cells mandatory on save/close, etc. using a macro, but is there a way I can prompt the end user before they tab to the next cell? I am envisioning a data validation box...

Hi everyone, I am trying to figure out how to lock auto-filter settings because I am trying to figure out how to get a work sheet to only display rows with certain values. There may be a better way to do this, but this was the first thing I thought of. Basically user A can only see rows...

Hi guys, I've written a Macro that will copy what's in cells and then insert that X amount of times in the cells below(Being used to copy formulas). This works perfectly once I've unlocked the sheet, however, I receive the following error when trying to run this macro in a locked sheet: Runtime...

I am trying to protect an excel file. It contains data in hidden tabs that I do not want shared. I know that its fairly easy to unlock an excel file that has been protected with a few lines of code. I had an idea but needed help to know if it is possible to do it. Is there a piece of code that...