We have a template created in Excel (32-bit) that uses CommandButton in a Worksheet to open a UserForm. We send it out to clients, and they populate the spreadsheet via UserForm for a number of years now.
One client had recently got their Office reinstalled and now they use x64 Office.
When they try to open the template, it now fails with "Member or data member not found" compile error on the line where we set the button's caption.

When they checked references - none of them are broken (the smaller picture is from the client).
Please note that the spreadsheet works fine in 32-bit on the office 14.0

How can we make our template work on the existing 32-bit clients as well as for the new x64 client?

Sergey

Attached Images

	ours.jpg (63.4 KB, 18 views)
	theirs.jpg (33.6 KB, 18 views)

The MSForms library is compatible with 64bit, otherwise you would not be able to use userforms in 64 bit office. The most likely issue is that the .exd file on the local computer is storing a different control version.

I would recommend that you replace the button on the worksheet with a Form button rather than ActiveX - that should solve your problem.