Macro in Excel 2007

Discussion in 'General Discussion' started by vishalvijayan, Dec 28, 2010.

  1. vishalvijayan

    vishalvijayan

    Joined:
    Dec 28, 2010
    Messages:
    1
    Likes Received:
    0
    I want to create a macro which can be used for all excel files.
    Can anyone guide me how to deploy a macros for for all excel files.

    Right now I get the following message - Trying to store recorded macro in personal macro workbook.
    I get error message "presonal Macro Workbook in the startup folder must stay open for recording"
     
    vishalvijayan, Dec 28, 2010
    #1
    1. Advertisements

  2. vishalvijayan

    novalight

    Joined:
    Jun 26, 2011
    Messages:
    1
    Likes Received:
    0
    Hi,

    I am using Excel 2007. I am trying to write a simple macro which will be triggered whenever the value of a specific cell is changed. There are numerous threads on this, but I would not get it working. I am not sure if the solutions/suggestions were meant for Excel 97 and they do not work in Excel 2007. Here is the codes they suggested.

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
    'Type your Macro name here
    MsgBox "A1 value is changing"
    End If
    End Sub

    When I entered these codes in the Sheet1 and/or This workbook, I cannot activate this marco from the excel spread itself. When I click on Macro, it did not show the Workseet_change as the marco or procedure under Macro. Can anyone help me ?
     
    novalight, Jun 26, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. spothineni

    Reports -Excel 2003 to excel 2007 conversion

    spothineni, May 14, 2010, in forum: General Discussion
    Replies:
    0
    Views:
    555
    spothineni
    May 14, 2010
  2. clootey
    Replies:
    0
    Views:
    726
    clootey
    May 12, 2011
  3. reehan

    Excel Macro

    reehan, Jun 14, 2011, in forum: General Discussion
    Replies:
    1
    Views:
    597
    Venky
    Jun 29, 2011
  4. rraman

    Excel Macro Help

    rraman, Jul 6, 2012, in forum: General Discussion
    Replies:
    0
    Views:
    473
    rraman
    Jul 6, 2012
  5. nurali2002

    Excel macro (need help)

    nurali2002, Jun 22, 2013, in forum: General Discussion
    Replies:
    0
    Views:
    747
    nurali2002
    Jun 22, 2013
Loading...

Share This Page