Forum Discussion
Making certain cells only changeable through double click
Hello everyone, I'm facing a problem for which I have no idea how to solve: I have the following Excel sheet: The cells are filled with the X by double clicking them. If I choose one...
Just some thoughts, as I haven't written VBA for a number of years now.
If the selection contents were written to a globally defined variable on selection change, the values could be written back to the target once the user has changed its contents. Care would be needed to ensure that the event handlers are not enabled when the contents are replaced.