Workbook is open, but yesterday evening I found a possible solution to
avoid the problem. I noticed that the code doesn’t work as long as one
of the buttons on the worksheet has the focus (?). So a simple solution
is to start the code with something like:
Cells(1,1).select

Now it’s working fine (though I still don’t know why it didn’t work the
other way)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/