Hi Thomas,

Where you've placed all these codes. To work properly some pieces shall be in standard module (like your knappen macro), other in Thisworkbook module (Private Sub Workbook_Open()) and some in a worksheet code (Private Sub Worksheet_Activate() or Change )

The next point is - please edit your post and use code tags - it increases readability of the code and is required by our http://www.excelforum.com/forum-rule...rum-rules.html