Hi,
I am working with Excel 2007 and using the "workbook_sheetchange" event to run another macro. I am using the parameters - "Sh" and "Target",
and trying to transfer those parameters to the macro.
the system could find the macro with the parameters !
I also don't see the macro in the macros list (from the developer tab in the application) - unless I delete the parameters...
Did anyone faced such a problem ?I need an urget rescue...
Thanks a lot for your help !
Neta Dekel.
Function and Sub with arguments are not displayed in the Macro dialog.
Really hard to know what you problem is as you have not posted any code.
How can I enter code ? just paste it to this box ?
Simplest is to attach workbook.
Otherwise post your code in this thread. Remember to use code tags when posting code.
Re: Macros with parameters stop working
Andy,
While examining the issue - I found the solution !- I had a problem in one of the functions...\
Thanks anyway
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks