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, 20 views)
	theirs.jpg (33.6 KB, 20 views)