Managed To Change The Icon On The Title Bar

Nov 28, 2006

I have managed to change the icon on the title bar but is it possible to change the "MICROSOFT EXCEL" wording next to the icon on the title bar

View 3 Replies


ADVERTISEMENT

Put An Icon In The Title Bar Of Workbook

Nov 19, 2008

Excel 2003. How can I put an icon in the title bar of an Excel Workbook? And can it be a .jpg or does it need to be a .icon. How can I put a title and NOT see " Microsoft Excel" in the title bar.

View 3 Replies View Related

Change Desktop Icon

Dec 4, 2008

I was wondering how I could change my desktop icon for one specific workbook to something other than the excel icon. I saw the below link (2nd tip) but that changes the icon for every file of a specific file type. I just want to change one specific file's icon on my desktop to something custom, like a clipart picture of my choosing. I also know that this can be done with shortcuts, but I need it to be changed on the original file. I tried using the IconChanger program, but the icon stayed with the file name so if I did a "save as" or emailed the file, it disappeared. I want it to stick with that file for good, or any file I duplicate from the original, and work on other computers as well.

View 2 Replies View Related

Change Shortcut Icon

May 31, 2007

How can I change an excel document's icon so it's not obvious until you click on it that the file is an excel one? I don't want to do the create shortcut business.

View 4 Replies View Related

Change Color Of Comment Icon

Apr 22, 2014

I want to know if we can change the color of the comment icon (when we add comment for a cell it gives a triangle form in red) can we change the color.

View 3 Replies View Related

Change Desktop Excel Icon

Dec 1, 2008

I was wondering how I could change my desktop icon for one specific workbook to something other than the excel icon. I saw the below link (2nd tip) but that changes the icon for any file of a specific file type.

I just want to change one specific file's icon on my desktop to something custom, like a clipart picture of my choosing. I've seen it done with certain companies changing the internet explorer shortcut icon linked to their webmail, changing it to their logo.

HTML http://www.windweaver.com/w95tips3.htm

View 4 Replies View Related

ActiveX Comboboxes Change To Icon

Jun 20, 2007

I have one sheet with about 100 activex controls (and another few 100 on the other sheets in the file), most combobox, but some checkbox as well. There are 30 of them lined up, one in each row. One at a time, one control will basically change to an icon only. If you select it in design mode, the name shows in the range name area of the toolbar, but when you select properties you get the properties for the sheet. Effectively I have an icon with nothing linked to it anymore.

For a while, it seemed to be somewhat random. But for the last few days, it is now cascading down. First combobox #6, then #7, etc. I'm now on #11 or so. Seems to happen when you save then reopen the file, not if you just keep working in the file without closing it.

The macros behind the boxes are still there and run once I recreate the missing box (normally with an Alt-D, and editing the properties; but I've also created from scratch from the toolbar, and used alt-C, alt-V) they work fine. I've run a compile, with no change. Any thoughts on finding the root cause? I thought it might be from blowing up a macro, but I've tried it without even editing a macro and it has the issue.

View 4 Replies View Related

Conditional Formatting - Change ICON SETS Color

May 23, 2014

Is it possible to change color for arrows icons in CF- icon sets? I would really like to have a five arrows pointing in different directions (all in different colors).

Can I do it in conditional formatting or should I go for "Wingdings" fonts and then change font color?

View 2 Replies View Related

Change Title In Legend On Chart?

Jul 31, 2014

How do i change a title in legend on a chart. i.e. I want the label to be MGRS 2%

Job Category
Category %
EE Total

Mgrs
2%
15

Supvr
6%
51

[code]....

View 2 Replies View Related

Change Page Title With Macro When Saving As MHT?

Mar 22, 2013

I want to use a macro to save an .xls file as an .mht file. I have:

ActiveWorkbook.SaveAs Filename:="C:ReportsBook2.mht", FileFormat:= _
xlWebArchive, CreateBackup:=False

which works for saving, but how can I Change the resulting web Page Title using VBA? I tried recording the macro as I changed the title and saved but nothing recorded for that. I know I can always just go in after the macro runs and manually change it but it seems like there must be another way.

View 2 Replies View Related

Change Formulas To Reflect New Sheet Title?

Apr 7, 2014

I have a workbook, everyday 2 new worksheets get added to reflect the previous day's work. How can I reflect in a formula to go to next sheet instead of the conventional naming 'Sheet1' G7?

View 6 Replies View Related

Email Icon In Spreadsheet As Per Email Icon In Quick Access Toolbar

Aug 20, 2014

I need to send out an order form (spreadsheet) to 100's of people that need to complete the form and email back to me as an attachment. If I was completing the order form myself I would use the "email" icon that I have pinned to my Quick Access Toolbar (QAT). However, most of the recipients don't even know the Toolbar exists.

Is there a way I can insert an icon / hyperlink in the spreadsheet that does the same thing as the QAT icon. I can insert text to say "click here to email your order" (or similar).

I need to keep it in an excel format and an icon is so much better that asking them to save to their hard-drive and attach to an email, etc.

The QAT icon is exactly what is needed but I need to provide a spreadsheet that works for folk who haven't got the icon.

View 4 Replies View Related

Managed To Lose The Properties Window Altogether

Oct 20, 2009

I have been playing around with my vb editor and i have managed to lose my properties window and now can't get it back.

I was playing around with the dockable option to see what it did and somehow i have managed to lose the properties window altogether. If i go to the view menu in the vb editor and choose properties window then nothing happens.

View 9 Replies View Related

Change Green "X" Standard Icon That Appears On Windows Taskbar

Aug 5, 2008

I'm trying to make my Excel/VBA application look as little like Excel as I can and there's now almost no trace of Excel - so is there any way I can replace the standard Excel green "X" icon that appears on Windows Taskbar with my own?

View 6 Replies View Related

Get Vba Code To Ignore An Error: Managed To Blag My Way Through Most Scripts

Mar 31, 2009

Somehow I have managed to blag my way through most scripts

View 2 Replies View Related

New Command Icon

Oct 15, 2008

I'm looking to have a doc where people time stamp their start and stop times. I have found that Control(apple) - Shift -semi colon works. The problem i'm having is that I want people to be able to use a command icon in their toolbars for this task as opposed to people have to use the keyboard. I can use a button with a macro but this is not possible as our excel corrupts when there are too many macro's

View 4 Replies View Related

Changing Icon

Oct 24, 2007

I'm using the bellow code which I think Igot from this site, to change the excell icon to my own, Only thing is that in the top left hand side of the workbook still says: "Microsoft Excel - My File Name". Does any of you fine people know how to get rid of the Microsoft Excel and show only "My File Name"?

Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Long) As Long
Declare Function ExtractIcon Lib "shell32.dll" Alias "ExtractIconA" (ByVal hInst As Long, ByVal lpszExeFileName As String, ByVal nIconIndex As Long) As Long

Const WM_SETICON = &H80

Sub setExcelIcon()
Dim lngXLHwnd As Long, lngIcon As Long, strIconPath As String

strIconPath = "My Path:MyIcon.ico"
lngXLHwnd = FindWindow("XLMAIN", Application.Caption)

lngIcon = ExtractIcon(0, strIconPath, 0)

SendMessage lngXLHwnd, WM_SETICON, False, lngIcon

End Sub

View 9 Replies View Related

VBA Editor Menu And Icon Bar

Feb 21, 2013

Sometimes I inadvertently remove/hide the menu bar and Icon bar from the VBA Editor. Not sure what I've done and not sure how I get it back.

View 4 Replies View Related

Add Icon To Macro Button Using VBA

Jul 25, 2006

The following code is for a macro button I have setup, but it is in text only form. I want to add an icon to the text. Also, are there other icons to use than the lame ones from Microsoft?

Dim myButton As CommandBarButton
Set myButton = Application. CommandBars("Worksheet Menu Bar").Controls.Add
myButton.Caption = "Hours Entry"
myButton.Style = msoButtonCaption
myButton.BeginGroup = True
myButton.OnAction = "Show_"

View 8 Replies View Related

Adding Icon Of Gain Or Loss

Dec 4, 2012

I have the data in

A1=30 and B1=40
A2=60 and B2=20

And I also 2 small Pictures ie picture1 and picture 2 which i insert in same excel sheet. I wanted to lookup C1 cell , if A1 is greater than B1 then Picture1 or vice versa.

View 1 Replies View Related

CF Icon Set Based On Text Not Values

Nov 17, 2013

I want to put in place a CF icon set of either a green tick or a red cross in cells A1:A20 but when I get to "Manage Rules option box" It is only showing me that I can use "values". Is there a formula that i can use to make it choose the icon set based on text of either "y" or "n" in cells A1:A20 .

I have tried to just change the font to "wingdings2" but other need to use the worksheet and they wont know to use the corresponding text of "O" & "P" .

View 4 Replies View Related

Disable Macro Icon In Menu Bar

Mar 9, 2009

i have 2 macro icons.

i want to disable the icons after its clicked once.

View 12 Replies View Related

Userform In Taskbar With Custom Icon?

Apr 15, 2012

I was wondering if this code is supposed to make the icon on the taskbar change to the custom icon as well?

If not, what would need to be added or changed to make it so?

It changes the Userform Icon without issue and adds the userform to the taskbar, but it is not updating the icon on the taskbar.

View 2 Replies View Related

How To Use Camera Icon Tool Using Macro

Jul 9, 2012

How to use the Camera Icon Tool using a Macro?

I want to copy the First Row which is the Column heading of one Sheet to a different Sheet
Example : From Col A till Col G First Row is to be copied as an Image. Normally I do it using the Camera Icon, however when I tried recording a Macro for the same it did not work..

So how do I that if I provide the Start Column and End Column Alphabet as a Variable is that possible.. I want this Image to not remain Volatile which is the case using the Camera Tool..

So, how do i get the picture of only the first row or any row and store it is an Image in a different sheet as static picture so that even when the sheet is moved to a different location it does not make a difference to the Image.

View 9 Replies View Related

Lost Relative Reference Icon

Aug 11, 2006

I went to record a macro but I can't seem to get the relative reference button anywhere. I am using Excel 97 - does anyone know why this might be or how I can get it back?

View 9 Replies View Related

User Programable Icon On Toolbar

Mar 24, 2009

I have an application macro which displays a Userform which lists and lets me select/load my favorite XL WBs. It also lets me add and/or delete favorites.

At present, I have to activate it with a Ctrl+Key combination.

Is there anyway I can assign it to an icon on the toolbar.

View 9 Replies View Related

Button Icon Folder Location

Oct 10, 2007

I am running WinNT and need to find the folder containing the default icons available for use on buttons in the toolbar window. I can copy the image but it saves as a picture (device independent bitmap). I want to be able to send the icon to other people so they can put it in their directory and choose to select it.

View 3 Replies View Related

Add Icon To Custom Toolbar Menu

Mar 4, 2008

how to manage a custom faceid. Though, I am not too sure as to how to assign an actual icon to a custom toolbar. I can try the pasteface method; though as the source file is a .png; the picture might be too small.

View 2 Replies View Related

Conditional Formatting - Icon Sets According To Value % Does Not Execute?

May 9, 2014

I'm trying to insert a simple conditional formatting rule - icon sets according to rule percentages I've selected (Green > 90%; Yellow < 90% but > 80%; < 80% red). The conditional formatting does not work once i select okay. For example. The data set shows 95% as red, 83% as red, it's just not working for me. I've tried opening a new workbook, new worksheet and nothing seems to work. I've been able to do insert this rule based on "number" setting but unsuccessful with percentages.

View 2 Replies View Related

Insert An Icon Relative To The Button Location

Jul 30, 2009

I was wondering if i could get a hand with inserting a file. Is there a way to insert the file and have it placed a relative distance from the insert button without using cell references?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved