Quote:
Originally Posted by sumesh56
Hi Garry,
thanks a lot. as you said when i changed the first line of the code, it is there in the macros dialog.what i understood is, there should not be the word "private" in the code.am i right?
|
I opened the worksheet. vba -click on the module and pasted yours. then i clicked on the macros in the code group. now i can see the code name in the list. But on vba doble clicked on the worksheet. clicked view code. pasted yours. went to macros. i cannot see the your macro there. it is not listed there. kindly detail it . thanks.