CopyTableToClipboard not working in macro after QV 12 upgrade

[taylormjd]

I have an incredibly simple macro (only 1 line!) to copy a table to the clipboard. 

Public Function Copy_LUM()
ActiveDocument.GetSheetObject("TB_LUM").CopyTableToClipboard (True)
End Function

4 out of 5 users of this particular model began experiencing problems with the macro yesterday.  When they click the macro button, it launches the Module Editor.

The 4 who are having problems just upgraded from QV 11 to QV 12.  I can't imagine that could have caused the problem.  I am on QV 12 and am not experiencing any issues.  But this is a 3 year-old QV model and the issue only appeared after the upgrade.

Anybody have any great ideas?

[marcus_sommer]

There are multiple causes possible. For example, changes within the various security-settings from the user and document, the copying object is missing or empty for the users (especially by using section access), any incompatibility between the various QV releases (it sounds that there multiple ones are mixed up), the code might not be accepted as valid anymore (a function expects to return a value which isn't specified - a change to a sub might be helpful), probably some more ...

- Marcus