Hi ,

I am creating a button thru macro and assign a function named Refresh.
It is executing well. While opening the workbook, there is an error pops up
"Macro name is not valid, check the name"

But macro is executing . IS there any way to find out what is the problem

My macro is in Module1 .

Sub refresh

end sub
OR
function refresh
End function
which is correct

but for both having issue