Edit locked cell in protected shared workbook (2 Viewers)

Acropolis

Registered User.
Local time
Today, 07:46
Joined
Feb 18, 2013
Messages
182
Hi, hoping someone has some bright ideas for this...

I am wanting to put a notes section into a workbook, where notes can be added about a particular row in a worksheet. There will be lots of rows.

I want these notes to be uneditable once they have been written, so they can't be tampered with.

Previously I have done this by unprotecting, then protecting the worksheet to enter the note which is captured in VBA. However this workbook needs to be shared, which means you can't unprotect or protect a workbook either in VBA or manually.

I have tried protecting the workbook with UserInterfaceOnly:= True, and that works great until the workbook is closed and re-opened then it fails and then can't unprotect or protect the workbook.

Excel really isn't the right platform for this, as it's basically a small CRM, but unfortunately for the moment it's the only thing available and that can't change for now, so need to try and find a way to make it work, any idea's?

Thanks
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 07:46
Joined
Jul 9, 2003
Messages
16,245
I note you have yet to receive an answer to your question. This is possibly because most people here are Microsoft Access orientated, although I do know there are a few people who are experts on Excel here. They are probably still on Christmas holiday! Anyway I thought bumping your question up the list might prompt and answer from someone.
 

Lindaad

Registered User.
Local time
Today, 00:46
Joined
May 27, 2019
Messages
9
Copy and paste to cancel cell protection.
Click cell A1>Shift + Ctrl + End to select all content > Ctrl + C Copy > Create a new Excel file > Ctrl + V to paste the copied content.
This will successfully unprotection Excel.
 

Users who are viewing this thread

Top Bottom