PC Review

Thread Tools Rate Thread

Macro in Excel 2007

New Member
Join Date: Dec 2010
Posts: 1
      28th Dec 2010
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"
Reply With Quote
New Member
Join Date: Jun 2011
Posts: 1
      26th Jun 2011

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 ?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 objects paste linked into PowerPoint 2007, why doespowerPoint reopen the excel file for each link even of the source excel isalready open? georgeb@stny.rr.com Microsoft Powerpoint 0 21st Nov 2012 02:11 PM
Run macro from shape when runnig macro in Excel 2007 bren Microsoft Excel Discussion 4 5th Dec 2009 10:03 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Microsoft Excel Misc 4 29th May 2008 06:29 PM
In Excel 2007 how to switch off macro with a macro =?Utf-8?B?TWlja3k=?= Microsoft Excel Programming 2 24th Sep 2007 11:17 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort =?Utf-8?B?R2F2aW4=?= Microsoft Excel Worksheet Functions 0 17th May 2007 01:20 PM




All times are GMT +1. The time now is 07:19 PM.