leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
Ive a workbook with several sheets and alot of locked cells in each but i seem to have hit a limit! the later sheets will not Lock the cells!?
really?
really?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Limited to the amount of Locked Cells?
Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,912
- Office Version
- 365
- Platform
- Windows
Hi
I am not aware of any limits. I also didn't see any reference to locked cells here: https://support.office.com/en-ie/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3
Can you explain further? How are you applying the protection and cell locking? Manually or using VBA? How many sheets do you have?
I am not aware of any limits. I also didn't see any reference to locked cells here: https://support.office.com/en-ie/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3
Can you explain further? How are you applying the protection and cell locking? Manually or using VBA? How many sheets do you have?
Last edited:
Upvote
0
