On Screen Error when highlighting Rows

..

Good afternoon all

With a lot of good work gone into setting up some coding for me,
I now seem to have a problem that if I want to change the size of the rows
from row (4 ) and downwards it is putting a lot of unwanted data into ALL of the cells
that are highlighted. The info is emanating from cell C5..

Attached is 1 document ( with a screen grab ), the second is the sample file.

I trust will be a eaze fix.???


Many Thanks in advance.


Peter

The quickest (but rough) way is to add this line of code in the event Worksheet_SelectionChange macro. This to avoid it triggering when you select more than one cell. In this case it will be three since you have merged cells:

Please Login or Register  to view this content.

..

Good evening Rollis13 and anybody looking at my thread

Thank you for your code works fine but only on sheet 1,

Any ideas here please.


Thanks again

Peter

Potholes...Compliments of the season to you...
You have duplicate code in all sheets...Delete this code from all the Sheet Modules and try this in...
ThisWorkbook Module

Please Login or Register  to view this content.

Also...amazing that you would go through all the trouble and code just to add a date to a cell...
Why not just allow date entry forcing to DD/MM/YYYY format...

My honest opinion...I would have only 1 Template and build a Userform Interface to populate this template based on selections and entries made...This will ensure no interaction with the sheets anyway...But that's just me...

I mean...you go through all the trouble to build a Userform Interface just to print sheets?

works fine but only on sheet 1

That's right but you duplicated your macro where you needed it, so, you need to change the code in every sheet where you have the macro with event Worksheet_SelectionChange.
Analyzed your project, as suggested by @sintek, it would be more 'professional' to have a single macro to trigger event Workbook_SheetSelectionChange.