locked worksheet

Hello. I apologize if this question has been asked. I tried to locate any threads pertaining to my issue but could not locate what I was looking for specifically, but I could have overlooked any that were posted. I have a locked worksheet with several unlocked cells. Some of the cells are...

Hi all I have a worksheet with a table. When adding a new line in a non-protected sheet, the table expands automatically. When the file is protected - with rights to add a new line and writing on a new line - the range of the table doesn't change. e.g.: I have data in rows 1 to 10 in a...

I have a shared workbook on a shared drive. About once a week it says its locked by another user and that I can only open as read only. The only problem is the user name it gives either has excel closed or has their entire computer turned off. I cant seem to figure out why.

I have a spreadsheet that I use for merging for details to word forms on a regular basis. My problem is that a colleague often opens the spreadsheet to obtain data and this then stops me from either using the spreadsheet to merge or from entering new data (using a user form). Is there...

I'm trying to use an activeX command button while the worksheet is locked to change the background cell color of some cells. The cells that I'm trying to color are not protected, but when the worksheet is in the locked state, I am unable to change the background color. Is there a way to use...