LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom macro and custom button VLExcel New Users to Excel 1 April 10th 10 12:16 AM
2003 - 2007 custom macro and custom button restore. Scott Sornberger Excel Discussion (Misc queries) 11 May 23rd 08 02:41 PM
Pivot Table custom column placement metrueblood Excel Discussion (Misc queries) 1 August 3rd 05 09:10 PM
Delete a custom button by holding down the ALT key and dragging the button off the toolbar Stephen[_8_] Excel Programming 0 April 4th 04 02:22 PM
Placement of Code Phil Hageman[_3_] Excel Programming 7 January 30th 04 02:06 PM


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"