DS and Paul B, thank you both so much for taking the time to reply. DS, you
got it exactly right. The user had indeed changed this to a shared workbook
and, after unsharing it, everything resumed working properly. You're a
lifesaver (a lot of folks are now very happy once mo) Thanks again to
both of you.

Best regards,

Paul

"DS" wrote:

Hi Paul - sounds like your workbook is shared. VBA projects are not viewable
in shared workbooks - if you unshare it, you'll be able to view the VBA code,
make your fix, and then reshare it.

If it works fine when unshared, it sounds like your user is hitting
something which isn't possible in shared workbooks (a number of formatting
options, for example, are not permitted in shared workbooks.)

Hope this helps
DS