Updated FaceIDs program

Some time ago, John Walkenbach at JWalk came up with an addin to show FaceIDs and their Control IDs.

Check out http://www.j-walk.com/ss/excel/tips/tip67.htm to see his version.

Incidentally, he said that I can do whatever I like with it because his PUP add-in has a MUCH better tool for identifying FaceIDs.

I have been using the original FaceID xla a fair bit in my work and have adapted it slightly. The reason I changed it is because most of the time, the FaceIDs are invalid for use on the menu, and I wanted to be able to see this when browsing the UserForm. Whenever the FaceID is invalid, the FaceID number will be black instead of the normal yellow. Download my version here.

Email me if you want a version for Excel 2003.

Check out the JWalk's site for install instructions.