Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: elenn la Simpatie.ro
| Femeie 24 ani Bucuresti cauta Barbat 24 - 55 ani |
|
TonyTzu
Moderator
Inregistrat: acum 12 ani
Postari: 252
|
|
1. The following macros are named with the thing they do (NoFill to apply no fill, Red for red fill etc.)
2. You will have to add them individually to PERSONAL.XLSB so they're available in all excel files.
3. If you don't see the PERSONAL.XLSB file, you must go to the DEVELOPER ribbon (activate from Excel Options - Customize Ribbon) and click on Record macro, then choose to Store macro in: Personal Macro Workbook, click OK, then immediately stop the macro recording
Note: if, for some reason, you don't see Customize Ribbon in Excel Options, then you must edit your Quick Access Toolbar, Choose commands from Developer Tab, select Record Macro and click the ADD button to put it in Quick Access Toolbar. Then do point 3. You can remove Record Macro afterwards from Quick Access Toolbar.
4. Open Visual basic editor (ALT+F11) and add the following macros to PERSONAL.XLSB (you can edit Module1 which is the empty macro you recorded at the previous point) Then you add a new module for each of the following (in the end you must have 5 modules):
Sub NoFill() Selection.Interior.ColorIndex = 0 End Sub
Sub Red() Selection.Interior.ColorIndex = 3 End Sub
Sub Blue() Selection.Interior.ColorIndex = 5 End Sub
Sub Yellow() Selection.Interior.ColorIndex = 6 End Sub
Sub Green() Selection.Interior.ColorIndex = 4 End Sub |
5. Now go back to excel and edit Quick Access Toolbar. Select Choose commands from: Macros and add all the macros above to the toolbar.
6. To edit their icon to show the corresponding color, click each of them on the right side frame, click the Modify button and look for a square that contains the corresponding color. Select it and click OK, then go to next macro.
Some options and info:
|
|
pus acum 6 ani |
|