Excel Tips & Trick!

ColorIndex

Whenever you want to make a color on the objects such as ...

Example as it applies to the Border object.
With Charts("Chart1").Axes(xlValue)
If .HasMajorGridlines Then
.MajorGridlines.Border.ColorIndex = 5 'set color to blue
End If
End With

Example as it applies to the Font object.
Worksheets("Sheet1").Range("A1").Font.ColorIndex = 3

Example as it applies to the Interior and Border object.
With Charts("Chart1").ChartArea
.Interior.ColorIndex = 3
.Border.ColorIndex = 5
End With

You have to know the index and this is all color indexes.


----------------------------------------------------------------------------------------------------

FaceID

You are able to have your own Command Bar and Control Button. It is easy, just follow this example then customize the FaceID.

This example adds a command bar button to a custom command bar. Clicking this button is equivalent to clicking the Open command on the File menu because the ID number is 23, yet the button has the same button face as the built-in Charting button.

Set newBar = CommandBars.Add(Name:="Custom2", _
Position:=msoBarTop, Temporary:=True)
newBar.Visible = True
Set con = newBar.Controls.Add(Type:=msoControlButton, Id:=23)
Con.FaceId = 17

You can see more button faces with all FaceID from the below following . . .
FaceID1100.dl
FaceID2200.dl
FaceID3300.dl
FaceID4400.dl
FaceID5500.dl
FaceID6600.dl
FaceID7700.dl
FaceID8800.dl
FaceID9900.dl
FaceID10033.dl

This is the link of the original website
www.excel-addon.com Email to my shop: Email My Shop
Email Me Now

Product List

Find Sheet tool
Price: $1.38
Click for downloading...
www.excel-addon.FindSheet.dl

Description:

This tool is used for finding a sheet which you want to find from many sheets in your Excel file. It is easier by searching automatically, just give some letters of your sheet name then this tool will help you to find it. No need to find it by yourself.
More than this, we give you a "Sum By Color" tool for free. This tool is used to get the sumary result of some values which is the same column and the same color. The detail, you can read from Howto.xls which is zipped together.

Encoding tool
Price: $2.50
Click for downloading...
www.excel-addon.Encoding.dl

Description:

Encoding.xla is a tool launched into Excel application for encoding some un-readable texts from email to be readable Thai language.

Password Recovery
Service list price
Unprotect "Password to open" price $4.00 / file
Unprotect "Sheet" price $1.00 / sheet
Unprotect "Workbook" price $1.00 / file

Description:

Someone who has a problem about forgetting the password for opening an Excel file or the password for unprotect the sheet or the workbook. Now we have the service to offer you, you can recovery your files back to reuse again.

Please send us your files by email to our online shop: nyodarchy@hotmail.com then we will do unprotect your files. If it is successfully, so we will immediately contact to you. You can pay via PayPal: nyodarchy@hotmail.com After we check your payment, we will send back your files with our password protection. So our password will be separately emailed to you for security on your data.
However, your files are top confidential. We will suddenly destroy them after we send them back to you already.

If you know something about your password, please give us some information such as its length, the alphabet used, the case of characters, digits, signs, etc. for reducing of the recovery time.
In case, we are not able to unprotect your file. We regret and please kindly accept our apology by now.
Finally, thanks a lot for your trust and using our service with Excel-AddOn Online Shop.

Calendar Alarm tool
Price: $1.63
Click for downloading...
www.excel-addon.CalendarAlam.dl

Description:

With CalendarAlarm.xla, you can set your own alarms via Excel application except from Outlook application.
Moreover, this tool has included the CALENDAR CREATOR function also!

Due Date tool
Price: $2.5
Click for downloading...
www.excel-addon.DueDate.dl

Description:

With DueDate.xla, you can set your due date schedule to "master" sheet then it will be located to the months calendar automatically.