View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
el_peacock el_peacock is offline
external usenet poster
 
Posts: 14
Default Custom button, code placement

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
--
---------
Gareth