Hi,

I have created a .xlam file to create a custom Menu. This .xlam file is placed in XLSTART folder. Under this menu, there are controls, buttons, and so on. I have created a userform with a textbox control in this .xlam file. As I create many workbooks, I would be navigating from one workbook to another frequently. I need to capture activeworkbook's activecell's columnwidth and need to display in the textbox of the UserForm.

In which procedure of the .xlam file should I write code so that it captures activecell's columnwidth and display in the userform

Thanks in advance,

Srinivas