Go Back   Access World Forums > Apps and Windows > Excel

Thread Tools Rate Thread Display Modes
Old 01-06-2019, 08:57 AM   #1
Newly Registered User
Join Date: Feb 2013
Location: West Midlands
Posts: 182
Thanks: 17
Thanked 14 Times in 14 Posts
Acropolis is on a distinguished road
Edit locked cell in protected shared workbook

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?


Acropolis is offline   Reply With Quote
Old 01-09-2019, 05:15 PM   #2
Uncle Gizmo
Nifty Access Guy
Uncle Gizmo's Avatar
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,226
Thanks: 512
Thanked 917 Times in 869 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Edit locked cell in protected shared workbook

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.
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 05-28-2019, 07:41 PM   #3
Newly Registered User
Join Date: May 2019
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Lindaad is on a distinguished road
Re: Edit locked cell in protected shared workbook

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.

Lindaad is offline   Reply With Quote
The Following User Says Thank You to Lindaad For This Useful Post:
Uncle Gizmo (05-29-2019)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Source workbook keeps opening when Destination workbook is protected??!?!?!? Virgo_Sam26 Excel 0 10-11-2012 08:32 AM
Shared Workbook Password Jason498 Excel 1 09-14-2010 08:41 AM
Activate a workbook based on a value in a cell in another workbook Rabbitoh Modules & VBA 1 07-28-2006 10:01 AM
Accessing a Excel protected workbook erncelen Modules & VBA 0 03-26-2004 10:07 AM
TransferSpreadsheet to Pswd Protected Workbook SerenityNet Macros 0 05-08-2003 02:17 PM

All times are GMT -8. The time now is 04:44 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World