Create Toolbar Button Andy 12/31/2008 8:41:01 AM I want to create a couple of buttons to place on my toolbar. Some to open commonly used files and one to load a template. Any links/pointers appreciated. Thanks

RE: Create Toolbar Button FSt1 12/31/2008 12:30:02 PM hi have a look here... http://www.contextures.com/xlToolbar02.html http://www.j-walk.com/ss/excel/tips/tip53.htm http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw regards FSt1 "Andy" wrote: [Quoted Text] > I want to create a couple of buttons to place on my toolbar. Some to open > commonly used files and one to load a template. Any links/pointers > appreciated. > > Thanks

RE: Create Toolbar Button Andy 12/31/2008 2:06:01 PM Found a much, much easier way. Just right-click toolbars>Customise>Macros. Drag and drop a custom button then modify selection and assign a hyperlink. Much easier for those of us that don't do VBA very well!!! Thanks anyway though, A "FSt1" wrote: [Quoted Text] > hi > have a look here... > http://www.contextures.com/xlToolbar02.html > http://www.j-walk.com/ss/excel/tips/tip53.htm > http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars > http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw > > regards > FSt1 > > "Andy" wrote: > > > I want to create a couple of buttons to place on my toolbar. Some to open > > commonly used files and one to load a template. Any links/pointers > > appreciated. > > > > Thanks

Re: Create Toolbar Button Gord Dibben <gorddibbATshawDOTca> 12/31/2008 4:17:05 PM Just for info. These customizations are saved in your Excelxx.xlb file. Many such customizations will increase the size of the file. This file has a tendency to become corrupt when it gets too large and will give you problems. Gord Dibben MS Excel MVP On Wed, 31 Dec 2008 06:06:01 -0800, Andy <Andy[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Found a much, much easier way. Just right-click toolbars>Customise>Macros. >Drag and drop a custom button then modify selection and assign a hyperlink. >Much easier for those of us that don't do VBA very well!!! > >Thanks anyway though, >A > >"FSt1" wrote: > >> hi >> have a look here... >> http://www.contextures.com/xlToolbar02.html >> http://www.j-walk.com/ss/excel/tips/tip53.htm >> http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars >> http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw >> >> regards >> FSt1 >> >> "Andy" wrote: >> >> > I want to create a couple of buttons to place on my toolbar. Some to open >> > commonly used files and one to load a template. Any links/pointers >> > appreciated. >> > >> > Thanks