This is a really minor issue that is easily fixable. This is a problem I have run into previously with Citrix as well. When you run a remote excel session that involves the PasteFace command, it sometimes gives you can automation error and craps out. The code works perfectly well locally, it's just remotely using MSTSC or possibly Citrix.
It crapped out toward the bottom of Sub CreateMenubar() where there is a .PasteFace command. The following would fix it:
On Error Resume Next
On Error GoTo 0
Log in to post a comment.