-
Denying a cell to be changed in any way
Hi! Problem for a learning vba-newbie:
1. I need a code that returns the full name of the active workbook into a cell named V_50300.
2. It should also deny the user to change anything within a cell named EXP_1010 if Range("V_50200").Value = Range("V_50300").Value.
The reason for this is that the full name of the active workbook can be depending on the text in EXP_1010.
If above is true and one tries to alter EXP_1010 then MsgBox "Changes to this cell is not allowed!"
3. This operation should always be running.
In case someone comes up with a solution: Where do I place the code?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules