ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protection occurring automatically after first cell entry (https://www.excelbanter.com/excel-programming/435544-protection-occurring-automatically-after-first-cell-entry.html)

Walt Herman

Protection occurring automatically after first cell entry
 
I am hoping someone has encountered this before. It feels like a virus to be
honest. But when I create a new workbook i am able to enter data in any cell
of that workbook but only once, from that point forward the sheet becomes
protected. So, I figure it is a wrokshet change macro but when I look in VB
editor no code exists. Is there a more subtle place this code might be
hiding?? ANy other suggestions? I would like to get my hands on the
dysfunctional person who engineered this idea!!!

Barb Reinhardt

Protection occurring automatically after first cell entry
 
Is there anything in the "ThisWorkbook" module?

"Walt Herman" wrote:

I am hoping someone has encountered this before. It feels like a virus to be
honest. But when I create a new workbook i am able to enter data in any cell
of that workbook but only once, from that point forward the sheet becomes
protected. So, I figure it is a wrokshet change macro but when I look in VB
editor no code exists. Is there a more subtle place this code might be
hiding?? ANy other suggestions? I would like to get my hands on the
dysfunctional person who engineered this idea!!!



All times are GMT +1. The time now is 10:59 AM.

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