Hi,
I found on SO nice function to get worksheet by its codename:
It works perfectly, but if I change default sheet codename, for example, from "Sheet5" to "Variables" it throws an error "Can not run macro. The macro may not be available in this workbook or all macros may be disabled".Please Login or Register to view this content.
I'm coding on MS Office for Mac, maybe there is some issue, I can't test it on Windows, right now
Bookmarks