locked

Hi, I have an unlocked merged cell that I want to automatically Autofit when multiple lines of text are added. The code below does that but for some reason changes the protection so that all but the 1st cell are locked resulting in the merged cell being locked. When I protect the workbook and...

Recently, a particular part of a form became locked (please see screenshot. The section in question is highlighted). I can't enter any new information or edit any existing information. I've tried googling for a solution, and I've tried going into Design View to check that various properties...

Hi there, So I have some PDFs embedded into my excel spreadsheet and I want to protect my worksheet as there is a lot of sensitive information on there as well as the embedded PDFs, however in order for someone to open the PDF then it needs to be "unlocked" in the protection settings which...

Hi Guys, First of all, I'm not sure if this is the correct section but if I'm wrong, Admins please move it to the correct one. Excel 2010 32-bit Windows 7 64-bit I'm a service centre guy and I currently encounter a very unusual issue. I have a user who's having a problem opening a shared...

I have a worksheet that another employee created but is no longer here. I am trying to understand the format to make updated changes. Part of the file seems to be locked, I think. I would like to send this form to someone to see the file in its full version. Please contact me with an email...

I have a Combo Box (Form Control, not ActiveX) which is Unlocked. When I protect the worksheet it returns this error when I click the box: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the...

Hey everyone! The Issue: Receive the title error message while trying to sort a column in Excel 2007/2003. Description: All Headers rows are formated as locked. Protect sheet function is active with the "Sort" selected. Filter function is active on every Header. The Solution: It's seem...

Currently I have a dashboard style excel document used by multiple users on a network, these users require read/write priviledges and as such only one read/write access file can be opened at a time because of the network.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

When I open my spreadsheet, it won't let me click on anything. I am able to scroll and use the up/down arrow keys, but it won't let me do anything with my mouse. I cannot do anything - can't click a cell, can't choose anything on the tool bar, can't even X out of the spreadsheet. Any help on...

I received a workbook. On one of the sheets there are some cells which cannot be accessed. I just cannot use mouse or arrow keys on the keyboard to get into these cells. When I click on one of these cells, nothing happens. What I find intriguing is that the sheet or the workbook are not...

I have Microsoft Excel for Mac 2011, Version 14.1.2 on my computer. The only reason I ever use Excel is to manage our family budget. I don't share this document with anyone/am not linked to any public network or server of any kind, and have never set permissions on the document. But, every...

We had an issue last week where a Shared Workbook was shown as locked by a user that was not in the workbook. Is there anyway to make sure the file is released by the user? Is there any way of finding out how many shared workbooks we have on our network? Thanks, Scott

Hello, I have a spreadsheet that multiple people use and it has a button to access another spreadsheet. If that sheet is open by someone else and another user tries to open it, the macro opens it read-only and presents a message box stating that someone else is in the file and that they won't...

What is the vba code to lock all the checkboxes on the active worksheet? I tried the following but not luck: ActiveSheet.CheckBoxes = Locked I am using Form Controls CheckBoxes not ActiveX checkBoxes.

I haven't seen an answer to this, but if its been already posted, just point me in the direction... I have a macro-enabled 2007 excel spreadsheet that includes both charts as objects in sheets as well as charts as separate sheets (the only macro in the workbook has nothing to do with charts)...

file locked for editing , can I kick the other user out if its my file? I have made an excel file where other people have to go in and update it. This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Is there anyway I can "kick" them out my...

Dear All, I am having trouble with Print Preview in a file with a Workbook_BeforePrint event. I have an Excel 2003 workbook that contains VBA code. In Private Sub Workbook_BeforePrint(Cancel As Boolean) I have code that if conditional formatting is turned on in a range of cells, then: Cancel...

Hi. My Excel file is located on network drive and I have a macros which automatically exports data from outlook message to excel file. In case some other user has opened this file I can not run a macros, because file is read only. There is a KB article "Macro code to check whether a...

There is probably a really easy answer to this question but I cannot seem to figure it out. I need to calculate the sum of pages faxed on a fax report at my office on an excel spreadsheet which is downloaded from our server. It appears the file is not meant to be used in excel but it downloads...

Does anyone have a macro already written (or know where I could find one) that would somehow indicate which cells on a spreadsheet are locked? Or can that be done with conditional formatting? I would think there is probably an easy way to do this, but I can't find it. It's okay if it...