What you can do on the EXCEL application!
To provide about how to use EXCEL application with your work or your life.
Interesting Links
Add-On or Add-In the new function on your EXCEL
Give the powerful on your EXCEL application with some new functions
- Excel-AddOn
- This is link that offering you some tools for adding onto your EXCEL application!
- Excel knowledge shared group
- Join us to share and get some know-how about the EXCEL application!
- What's Excel-AddOn
- Learn more about Excel-AddOn
Tips & Trick!
It's easy, just you know.
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
Excel-AddOn
Improve your EXCEL to be powerful
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.Interesting Microsoft Office
Programmer Reference
Written by active and popular members of the Excel community, this guide includes coverage of all the new features.
Excel VBA
Programmer Reference
To fully appreciate the application development features available in Excel.
Give me your advices
Loading poll. Please Wait...
by YODARCHY
YODARCHY
I'm an engineer who wants to share my interesting on ..
- 0 featured lenses
- Winner of 3 trophies!
- Top lens »
Feeling creative?
Create a Lens!
Explore related pages
- Lens Workshop Addon for Firefox Lens Workshop Addon for Firefox
- Recover Excel File Not Saved, Crashed or Closed After Saving - Retrieve Excel Spreadsheet Recover Excel File Not Saved, Crashed or Closed After Saving - Retrieve Excel Spreadsheet
- Ten Best Firefox Plugins for Web Developers Ten Best Firefox Plugins for Web Developers
- Twitter Toolbox Twitter Toolbox
- 10 Add-Ons To Improve Firefox 10 Add-Ons To Improve Firefox
- 20 Essential Firefox Addons 20 Essential Firefox Addons
