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/