Results 1 to 8 of 8

Can one or two macros do all this through email?

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-11-2006
    MS-Off Ver
    2007
    Posts
    438

    Can one or two macros do all this through email?

    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
    Last edited by VBA Noob; 03-18-2009 at 04:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1