ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Protection (https://www.excelbanter.com/excel-programming/406842-worksheet-protection.html)

MikeH2

Worksheet Protection
 
I placed a Listbox onto a worksheet. The cell that is the "Linked Cell" is
set in the Allow users to Edit Ranges Section. But when the sheet is
protected I constantly get the message, "The cell or chart you are trying to
change is protected and therefore read-only." I can't seem to get past this.
Ideas?

Dave Peterson

Worksheet Protection
 
Unlock the linked cell seems like the simplest solution.

MikeH2 wrote:

I placed a Listbox onto a worksheet. The cell that is the "Linked Cell" is
set in the Allow users to Edit Ranges Section. But when the sheet is
protected I constantly get the message, "The cell or chart you are trying to
change is protected and therefore read-only." I can't seem to get past this.
Ideas?


--

Dave Peterson


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com