Is it possible to have 2 fill buttons set to different colors on the formatting toolbar in Excel 2000? I couldn't find any information on the Microsoft site. Thanks in advance.
I don't know of a way to have 2 fill buttons set differently, but if you have 2 colors that you use all the time, you can set up a button with a macro to change to one of those colors by following these steps (in this example we will use Red):
1. Close all open workbooks, then open a new workbook and save it as Macro.xls
2. Go to Tools | Macro | Record New Macro
3. The 'Record Macro' widow will come up. Enter the name of this macro, in this case I suggest using the name of the color you select (ex. Red)
4. Click on the fill button and choose the appropriate color (ex. Red)
5. Click the 'Stop Recording' button
6. Go to Tools | Customize and click on the Commands tab
7. In the Categories box slide down until you see 'Macros' and click on it
8. Click and Drag the 'Custom Menu Item' up to your toolbar
9. Right click on the 'Custom Menu Item' now on the toolbar and at the bottom choose 'Assign Macro'
10. The 'Assign Macro' window will come up. Click on the macro you just recorded (ex. Red) and click OK
11. Right click on the 'Custom Menu Item' and in the box next to name, type in the name of the color (ex. Red) and hit Enter
12. Close the 'Customize' window
You now have a button that will automatically fill in the cell in the color you chose (Red in the example). To make another button for another color, repeat steps 2 to 12. (I don't think I left any steps out, but if I did just ask and I will try to clarify)
After making all your buttons, save and close the Macro.xls sheet and open a new spreadsheet. When you hit one of the buttons, Excel will automatically open the Macro.xls spreadsheet (although it will ask you first, if you have the Macro protection turned on).
I hope this helps
Jimmy Simpson
You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.
You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.
=HYPERLINK("[Budget]June!E56", E56)
try
=HYPERLINK("[Budget.xls]June!E56", E56)
ie
=HYPERLINK("[Budget.xls]June!E56", E56)
Examples
The following example opens a worksheet named Budget Report.xls that is stored on the Internet at the location named www.business.com/report and displays the text "Click for report":
HYPERLINK("http://www.business.com/report/budget report.xls", "Click for report")
The following example creates a hyperlink to cell F10 on the worksheet named Annual in the workbook Budget Report.xls, which is stored on the Internet at the location named www.business.com/report. The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text:
HYPERLINK("[http://www.business.com/report/budget report.xls]Annual!F10", D1)
The following example creates a hyperlink to the range named DeptTotal on the worksheet named First Quarter in the workbook Budget Report.xls, which is stored on the Internet at the location named www.business.com/report. The cell on the worksheet that contains the hyperlink displays the text "Click to see First Quarter Department Total":
HYPERLINK("[http://www.business.com/report/budget report.xls]First Quarter!DeptTotal", "Click to see First Quarter Department Total")
To create a hyperlink to a specific location in a Microsoft Word document, you must use a bookmark to define the location you want to jump to in the document. The following example creates a hyperlink to the bookmark named QrtlyProfits in the document named Annual Report.doc located at www.business.com:
HYPERLINK("[http://www.business.com/Annual Report.doc]QrtlyProfits", "Quarterly Profit Report")
In Excel for Windows, the following example displays the contents of cell D5 as the jump text in the cell and opens the file named 1stqtr.xls, which is stored on the server named FINANCE in the Statements share. This example uses a UNC path:
HYPERLINK("\\FINANCE\Statements\1stqtr.xls", D5)
The following example opens the file 1stqtr.xls in Excel for Windows that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10:
HYPERLINK("D:\FINANCE\1stqtr.xls", H10)
In Excel for Windows, the following example creates a hyperlink to the area named Totals in another (external) workbook, Mybook.xls:
HYPERLINK("[C:\My Documents\Mybook.xls]Totals")
In Microsoft Excel for the Macintosh, the following example displays "Click here" in the cell and opens the file named First Quarter that is stored in a folder named Budget Reports on the hard drive named Macintosh HD:
HYPERLINK("Macintosh HD:Budget Reports:First Quarter","Click here")
You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.
HYPERLINK("[Budget]June!E56",E56)
To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September".