Excel - mysterious formatting information message

  howryou 23:10 19 Feb 2008

I've created my own Sudoku solution and grid to assist solving these puzzles and they include macros.

I the individual boxes I can have the numbers, 1, 2, 3, 4, 5, 6, 7, 8, 9 and when I have figured out a number in another cell, I remove it from the ones in the same 9 squares and from the Horizontal row and column.

However, I've somehow picked up a formatting issue not of my own doing and would like to know how it is doing what it is.

When I am removing a number from my list and press Enter, an information box headed Sudoku pops up with the message, you can only enter whole numbers from 1 to 9.

It wasn't me that created it, I can't find it in any macro, not conditional formatting


  VoG II 08:42 20 Feb 2008

Right click the sheet tab > View Code. Is there anything in the code window?

  Simsy 10:28 20 Feb 2008

use "Data validation", and not permit blanks?



  howryou 18:28 20 Feb 2008

Data Validation - never gone there before and that's what it was

Thank you as always

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

30 UK artists have created vibrant posters celebrating Pride London

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?