Macro in Excel 2007


Joined
Dec 28, 2010
Messages
1
Reaction score
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"
 
Ad

Advertisements

Joined
Jun 26, 2011
Messages
1
Reaction score
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 ?
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top