Hi all,

this is my first post to the forum

I have a small problem with my command button in excel.

A short description of my program would be I made a form with a save button that opens up another excelbook and save some data from the form in the other book and then closes the other book. I put all the code in the buttons "on click" part.

The problem is that the users cannot click on the button (totally unclickable) if they have an active cell where they wrote something in.

The workaround is simply to click in a new cell (then the button works fine) but if you start to type anything in the new cell the button becomes unclickable again.

The problem is not everyone that will use the program have the time/patience to click in a new cell before pushing the button so I guess Im looking for something like
button on mouse over get focus or something but I cant get it to work.. could someone please enlighten me

Thanks