Hi! Steve, Sorry for delay in responding. I have Excel workbooks with xlsm & xlsx extensions and need to apply custom stand alone icons which I find rather not possible. The icon change through Windows Explorer Tools>Folder Options>FileTypes>Advanced menu applies to all files.
There are some workbook-open VBA codes on the net, but don't work and I can't remove bugs. If you happen to come across a way to create stand alone Excel file icon, please do guide. Thanks, Mahess On Thu, Sep 15, 2011 at 12:41 PM, Steve May <stevema...@gmail.com> wrote: > Hello Mahess, > I haven't changed the logo of the file but it's format. If you check the > file extention of the file it is .xlsb > Thank you > Steve. > On Thu, Sep 15, 2011 at 11:10 AM, Mahess Desai <mahessbde...@gmail.com>wrote: > >> Hi! Steve, >> >> When I down loaded your attachment, found that the Excel file has a stand >> alone logo which has continued to remain in my computer also without any of >> my DLL files modified. >> >> I have been not able to pick up different logo for four files in a folder. >> >> Can you please guide how did you put a different logo on your file? >> >> Mahess (learner) >> >> >> On Tue, Sep 13, 2011 at 11:49 PM, Steve May <stevema...@gmail.com> wrote: >> >>> Dear Noorain, >>> >>> Thank you very much for your quick respose. >>> I am attaching a modified file from excel-macros@googlegroups.com, with >>> my request. >>> Thank you once again. >>> >>> >>> On Tue, Sep 13, 2011 at 10:55 PM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Dear Steve, >>>> >>>> Can you u provide excel sheet with Example.. >>>> >>>> On Tue, Sep 13, 2011 at 10:21 PM, Steve May <stevema...@gmail.com>wrote: >>>> >>>>> Dear Friend, >>>>> >>>>> I have table with many columns. If one of them is gender and it >>>>> contains either 'Boy' or 'Girl'. >>>>> 1. If I filter only 'Boy' then the Header or Footer must have "Boy" in >>>>> it. >>>>> >>>>> 2. Further before printing excel must ask what should be there in the >>>>> header or footer. >>>>> 3. Automatically it must add a word or words related to the filtered >>>>> word. eg. If I filter 'Boy' then can it have a "Boys Only" >>>>> >>>>> Thanking you in Advance. >>>>> Bye for now >>>>> Steve >>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> >>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel