Worksheet Says Locked For Editing By A User Who Is Not In Workshe.

I think I have been asking the incorrect question in previous posts. I have 70 files on a shared drive that I run 1 Macro on. However, sometimes my co-workers are working in the documents and I'll get a "NYC is locked for editing" message. When this happens, I have to re-run my entire Macro all over again. Is there a way to see if any of the workbooks I am trying to open and run a my Macro on are "locked for editing". If any are locked for editing, then I would want to exit sub before running my main Macro. I have all of the file paths in a workbook in column A. Thanks in advance




example.....

I:\Shared\NYC.xls
I:\Shared\Boston.xls
I:\Shared\LA.xls
I:\Shared\Chicago.xls
I:\Shared\Philly.xls

I have an excel 2000 spreadsheet which is locked (worksheet protected using a password). For cells requiring direct user input, the cell's 'locked' property is unticked. However, if text is copied from a Word document into one of these unlocked cells, this property is then set to 'locked', even though the worksheet is protected (and 'format cells' is greyed out). This means the user cannot change or delete the info they've just pasted!

the same also occurs in Excel 2003

How can I prevent this change to the 'locked' property?

Thanks in advance!

At work we have Excel 2007 and we have a log of all the tests we do that only the Managers can edit, but we can all view. When we switched from 2004 to 2007, if the excel file was open it stopped saying who it was "locked for editing" by. It did say it in 04, but not in 07. Every other file (ones that are not locked w/ passwords) will say who it is locked by. The locked log simply says locked by "another user". Is there anyway to change this so it says who it's locked for editing by?

Situation : Windows XP Sp2 clients with Office 2003 Sp2 and Samba Domain:
(running Red Hat Enterprise Linux AS release 3 with Taroon Update 7)

On a random share are some XLS documents opened with Excel 2003.
When I open for example document.xls with user “X” (username filled in in
Excel General Options > User name) user “Z” cant open the document because
the document is locked.
Normally the username of the user who has the document open will show up,
when you try to open a document which is already opened.

But in this case, the username shown in “Document.xls is locked for editing
by random name” isn’t really the person who has the document open, it shows
the username who LAST SAVED the document, or in some cases, the user who has
last opened the document.

For example: Document.xls, last saved and closed by user “X” (shown in the
properties of the document) is being opened by user “Y” (also shown “Y” in
EXCEL user options). User “Y nor saves or closes the document, just opens it.
When user “Z” now tries to open the document, a message wil appear:

“ File in Use “
“document.xls is locked for editing by “X”

But user “Y” has the document open, not user “X” …

This is really frustrating some people here, because they don’t know who
really has the document open.

Anyone familiar with this situation ?
For more info please ask.

I have an excel 2000 spreadsheet which is locked (worksheet protected using a password). For cells requiring direct user input, the cell's 'locked' property is unticked. However, if text is copied from a Word document into one of these unlocked cells, this property is then set to 'locked', even though the worksheet is protected (and 'format cells' is greyed out). This means the user cannot change or delete the info they've just pasted!

How can I prevent this change to the 'locked' property?

Thanks in advance!


answer seems to be to disable Paste, and redirect ^v to paste special the value

Using Active Directory, MS clustered file server, Office 2003

When a group of users access the same file, of course they get a
message stating that
the file is locked by some other user and it usually gives the person's
name that has the
file locked. The exception is that when a particular user has the file
locked, it does not
give that person's name, it simply says 'Nursing'. Since the word
nursing does appear
anywhere in the user's active directory property sheet, I was hoping
somebody could
tell me where excel is getting the data for the user who has the file
locked.

Thanks in advance,

John

Using Active Directory, MS clustered file server, Office 2003

When a group of users access the same file, of course they get a
message stating that
the file is locked by some other user and it usually gives the person's
name that has the
file locked. The exception is that when a particular user has the file
locked, it does not
give that person's name, it simply says 'Nursing'. Since the word
nursing does appear
anywhere in the user's active directory property sheet, I was hoping
somebody could
tell me where excel is getting the data for the user who has the file
locked.

Thanks in advance,

John

Hi, I don't know if this is the correct thread, but here goes.

When users try to access a shared Excel workbook from the server, we get a message saying that the file has been locked for editing by "username". The only problem is that the file has already been closed by the user.

I can go to computer management and release the share of that file, but I'm looking for a fix to avoid any user intervention.

This has been going on for the last couple of days and is driving me nuts.

Any suggestions?

I cannot view or change the data in my worksheet because I am getting this
message. Why, and how do I unlock it?

Thanks for your help.

gman

Here is my Dilemia

I have a worksheet that has been designed to allow the user to enter data, in certain cells of the worksheet are formula to do automatic calculations as the user enters data. Here is my dilemia

a) I need the cells with the formula's to be locked so the user cannot delete or alter them.
b) In cases there may be a case where rows will have to be deleted or inserted, depending on the data entered.
c) The sheet needs to be protected to avoid the user from altering the sheet i.e. design etc.

I have found the problem is that i can lock out all the cells that i do not want the user to alter, and i can protect the worksheet and allow users to have certain edit right. But the problem i am facing is that when you have locked or protected cells on a wprksheet and you protect the sheet, then you can not delete or insert rows.

Is there a way that allows the sheet and formula to be locked, but also allow the user to delete or insert rows if they need...???

I hope this explains every thing...

Sorry for some reason pc acting funny and posted this twice...

I have written a usage log into a spreadsheet to see who is entering the sheet, this is fine but some user names are not shown, only the time they entered, all macros are activated but there name is hidden, why is this?

Also if someone is in a sheet no matter what worksheet they are in and i try to go in, it comes up read only, but instead of it saying, "The sheet is locked for editing by FBF" i says " The sheet is locked for editing by ."

Anyone got any answers please

Thanks

FBF

Hi everyone,
I am trying to design a worksheet so some of the cells will be locked for editing but others the user will be able to type in freely. When I protect the sheet, everything gets locked down. How do I specify which cells I want protected?

Thanks,
Will

Ladies and Gentlemen:

In my worksheet, I have a column with all cells in that column locked
(It is a must and I CAN NOT unlock any cell in that column). There are
a few cells UNDER OTHER COLUMNS unlocked for user to input their data.
Then the whole worksheet is password-protected. My question is how to
allow user to copy one ROW and paste it into another row without
unprotect the worksheet? Please keep it in mind that there is at least
one cell in EACH ROW locked where user CAN NOT modify the value in that
cell.

Thanks for your help!

George

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 file? Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker..
Its really doing my head in... pls help

Heres a question.

Is it possible by VBA or other means to allow a user to format cells within a protecetd worksheet.

I jave a worksheet which has locked cells and is also protect, to protect formula's

What i would like todo is on the cells that the user can enter data, is to allow them to use the Undeline, Bold, and Italic functions only.

Is this possible

G

Looking for a way to unlock a shared excel workbook on a network drive. It currently states that a user has the file locked for editing which he does not. He is not in the file and he has already rebooted his machine. I cannot save as and write over the existing file because the file is supposedly "In Use" by the person whom it claims has it locked for editing. I cannot save as a new name because over 200 people use this file and are already mapped to its home location. Help!?

Hi all - I have a worksheet that only allows users to select unlocked cells so that they can only input the correct data (there is a host of formula, etc around this). I grouped a selection of the rows as it looks quite busy otherwise, but would like end-users to be able to open these up to see the budget / cumulative figures as and when they want. Problem is that the grouped fields are unaccessible (i.e. cannot be expanded / contracted) once the worksheet is locked - does anyone know how to make these available in a locked down worksheet??

Many thanks in advance for any help and it's worth noting that I'm working in Excel 2007

doowop

Hi,

I was wondering if i could get some help with my problem. In a workbook, i have two worksheets, namely, Schedule and Control.

I have VBA codes written in worksheet "Control". The problem i'm having is that i was trying to stop users from editing a certain number of cells in worksheets "Schedule" but not all the cells.

For example, Cells from D10 to F30 are to be locked (not allowing to be edited) but users can edit cells from G10 to I30 in worksheet "Control".

So i have a simple code written in "Control" worksheet but got error message saying "method data not found".

Worksheets("Timesheet").Activate
Worksheets.Range("D8:F10").Locked = true

Thank you in advance

I have locked all of a worksheet, except for a data entry portion. During
the locking proceedure, excel appears to give options for allowing the user
permission to use certain functions while the worksheet is locked, such as
"sort". However, that is not being allowed. Any ideas?

Hello All,

At times i get this problem when an Excel file opens as a read only & says that its locked for editing by a user. However, the user is not logged on and his computer is switched off. This does not happen to any fixed user, but to almost everyone in my department as well as across departments.

At times I am unable to edit a file as it says its locked for editing by myself.

Any suggestions would be helpful.

Regards,
Sandeep.