Most valuable professional
  • Hot Topics

Excel Cancel=True not working on one worksheet in a workbook

I have a workbook with multiple worksheets (Jan - Feb), each with a load of data. Each sheet is set up to change colors (among other things) if a cell is double-clicked and each private sub ends with cancel=true. On one of the sheets (Feb), it just doesn't work (although it HAS worked on that sheet until relevant changes have been made). All the other sheets function properly and do not go into the cells edit mode when double-clicked. February goes into edit mode every time. The code is the same for each sheet. Any ideas why this is happening?

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of February 13, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel