Hello all,
I have a fellow collegue named Brianna who works in a different location than me who needs to automate a task in Excel 2003. Brianna is not that knowledgable in Excel other than the very basics. Therefore, I would like to email her a file/files that can accomplish this task for her with very minimal effort on her part. Here's what I need...
I need to create a new toolbar in Brianna's Personal workbook named "Food".
I then need to create a toolbar button (on the "Food" toolbar) named "Fruit".
I then need the "Fruit" button to execute a macro named "Orange".
Here is the "Orange" macro...
Sub Orange()
ActiveCell.FormulaR1C1 = "Orange"
Range("D2").Select
End Sub
Can this be done?
Kudos to anyone that can pull this one off!

Thanks much,
duugg
Bookmarks