I have a protected sheet with hidden formulas in column E but not locked.
Occasionally the user must change the formula to a fixed number.
Is there a way to display an alert in trying to modify these cells contents?
Thanks
I have a protected sheet with hidden formulas in column E but not locked.
Occasionally the user must change the formula to a fixed number.
Is there a way to display an alert in trying to modify these cells contents?
Thanks
Use a Selection Change Event handler to store the formula when you select a cell in column E. Use a Change Event handler to monitor changes in column E. If a change is made, display a message and seek confirmation. If necessary, restore the stored formula.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Would you please show me?
The formula starting in E5 is =IF(F4="";"";F4) coppied down to E157.
Anyone please help...
Try something like this. paste into sheet Module.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
If you "Exit Sub" you won't re-enable Event Handling.
...I think we assumed it was sort of obvious.
add theimmediately prior to the Exit SubPlease Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Richard, with us, non experts, you can never assume....LOL
Of course...My bad guys...Was not thinking....
Last edited by sintek; 06-24-2017 at 01:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks