Sudoku Assistant Files

v6.0

NEW FEATURES - Follow Conjugate Pairs and Follow BiValues

• Added option to highlight BiValue Cells

• Added Right-Click BiValue Actions when Pencilmark Cell has only 2 possibilities

• Added Right-Click Follow Congugate Pair Options

• Fixed bugs with Paste Puzzle

• Fixed serious bug with N-Fish spotter

• Improve Red/Blue colouring for Follow BiVals

• Improve Follow BiVals to include hidden singles

• Colour of selected cell highlighting changed from ORANGE tones to LIGHT BLUE tones

• Many code improvements, especially with BiValue search

• Make Messages box resizable

• Fix bug with cross-hatch shading of intersecting pointing pairs/triples

• Fixed bugs with follow biVal actions on right-click for non-pencilmarks cells

v5.48

• Improve Find Naked Singles code and Find Hidden Singles code

• Combine Find Naked Singles/Find Hidden Singles

• AT LAST - All dialogues/UserForm display on same screen as spreadsheet. Thanks Gemini

• Added some colour to the Messages box

• Added https://www.sudocue.net to the Generate Puzzle options

• Added Copy Scratchpad State button on Assistant sheet

• Fixed bug with UpdatePencilamrks and improved processing speed significalntly

v5.47

• Puzzles can now be pasted in sudowiki.org format - including partially complete puzzles. Solved cells and pencilmarks are restored to Snapshot1 before being appied.

• Enhanced messaging when seeking Hidden Singles

• Whan a snapshot is taken, a SudokuString Version B (as per https://www.sudokuwiki.org/Sudoku_String_Definitions) is created and stored in the notes of the snapshot by default. This allows to you to get a hint from sudukuWiki.org if you get stuck!

v5.46

• Modified Paste Puzzle to paste puzzles of 81 lines (like when copied from https://www.sudokuweb.org/)

• Expanded Generate Puzzle options & updated Lnks & References to document

• Added option to change co-ordinate numbering system to various formats

• All Data Validation Input and Error messages are now defined as Public Const strings, making it possible to translate these into another language should anyone desire to do so.

v5.45

• Fix crash where Start Puzzle crashes if Tips have been turned off

• Preserve Auto and Manual highlighting settings when switching between modes instead of resetting to defaults each time

v5.44

• Mostly code efficiencies in a (partly successful) attempt to reduce the screen static after clicking Start Puzzle from the Puzzle tab

• Add explanation for 2-String Kite to Help>Glossary

• Fix error where highlighting Rows/Columns did not mark pencilmarks of Givens correctly

• Fix error so right-click options are reset when leaving the Assistant sheet

v5.43

• Fixed bug where right-clicking on cell and choosing Eliminate Digit causes a crash

v5.42

• Added Eliminate and Add Pencilmark options to menu when right-clicking a pencilmarks cell and removed most standard items from right-click throughout the Assistant sheet

• Added Jump to Eliminations Grid when right-clicking within puzzle area

• Fixed bug that caused a crash if a Value cell was double-clicked when there were no Focus Digits

v5.41

• Added extra options when copying a puzzle from the Puzzle page

v5.4 introduced the option of Generating a puzzle from the puzzle page. This requires:

1. Internet access - the puzzles are generated using https://you-do-sudoku-api.vercel.app/api

2. Enabling Microsoft Scripting Runtime from VBA - from the Visual Basic UI, click Tools > References... and find the option

• Note: Develper options need to be enabled to access the Visual Basic UI - this can be done by navigating to File > Options > Customise Ribbon, and under the Main Tabs, make sure the Developer Check Box is selected.