G
Guest
Hi
I have created a custom button which I have placed on the toolbar. The
button converts the text in the selected cells to uppercase.
I saved the macro code in Visual Basic Editor - 'This Workbook' for Book.xlt
I have created in the XLstart folder on my PC (I want the button to be
available in all new workbooks as well as any others I may open).
Every time I create a new workbook, I get the 'This workbook contains
macros' warning because of my button. Does anybody have a decent solution to
this problem? - Either so that the macro warning is bypassed (I appreciate
disabling safety features is not ideal), or so the macro code isn't
specifically stored in a template but in the Excel program itself (as the
other standard toolbar buttons must be).
Thanks for any help
I have created a custom button which I have placed on the toolbar. The
button converts the text in the selected cells to uppercase.
I saved the macro code in Visual Basic Editor - 'This Workbook' for Book.xlt
I have created in the XLstart folder on my PC (I want the button to be
available in all new workbooks as well as any others I may open).
Every time I create a new workbook, I get the 'This workbook contains
macros' warning because of my button. Does anybody have a decent solution to
this problem? - Either so that the macro warning is bypassed (I appreciate
disabling safety features is not ideal), or so the macro code isn't
specifically stored in a template but in the Excel program itself (as the
other standard toolbar buttons must be).
Thanks for any help