Shanaka Fernando
New Member
- Joined
- Sep 30, 2021
- Messages
- 12
- Office Version
- 2010
- Platform
- Windows
i need vba code to lock the formula cell in worksheet, formula =UPPER(SpellNumber()) ,
-
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.
lock formular cell in worksheet
- Thread starter Shanaka Fernando
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
Can you explain in more detail exactly what you are looking for?
To "lock" any cell, you typically use a combination and cell locking and sheet protection (no VBA required).
See: How to lock cells in Excel
Can you explain in more detail exactly what you are looking for?
To "lock" any cell, you typically use a combination and cell locking and sheet protection (no VBA required).
See: How to lock cells in Excel
Upvote
0
Shanaka Fernando
New Member
- Joined
- Sep 30, 2021
- Messages
- 12
- Office Version
- 2010
- Platform
- Windows
i want to lock only formula cell without sheet protection (this workbook is use by multiple users and i want to lock the formula cell without access to edit .)
the formula cell is not stable cell
when users are delete row or add new rows it will be move.
the formula cell is not stable cell
when users are delete row or add new rows it will be move.
Upvote
0
Similar threads
- Question
