View Macros window presented when attempting to run Macro
Hi,
I am attempting to add a Private Sub Worksheet_Change(ByVal Target As Range) macro to a worksheet.
When I click run I am prompted to select an existing Macro or type a new name for Macro. If I type a name and select Create, a new Macro (separate from the one I am attempting to run) is created.
I can not get out of this loop! Suffice to say I'm a n00b at this. Any and all advice appreciated.
Hi, ckarra,
code goes behind the sheet which you want to monitor and will get started on any direct change to a given cell/range or via Query. You would not need to start that macro by hand and will not find it listed int the macro list.
If the macro won´t get fired please make sure that events have been enabled in Excel by entering into the Immediate Window in the VBE
and hit Enter (of course make any macro available in the workbook as well).
Application.EnableEvents = True
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ckarra 
Register To Reply
Bookmarks