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
What's the purpose of the function?
I really don't see the need for the function to get worksheet by code name...
You can simply use worksheet code name like below... assuming Variables is set as it's code name.
If you need to pass that on to another procedure etc, you can declare it as public/global variable.Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
It's like a some sort of security if few workbooks are opened and sheets have same names.
I see. In general I don't recommend using sheet code name for code that doesn't run on the workbook containing the code itself. Specifically for that reason.
You should use Sheets(Index#) or Sheets("SheetName") both of which can and should be qualified with workbook object.
I tested the function, but had no issue on my end.Please Login or Register to view this content.
0.JPG
What exactly throws the error - that isn't a macro?
Rory
Oh, I have dew updates:
1) rename sheet codename - works perfectly on Windows (I've tested few minutes ago) and throws and error on Mac, so it's kinda an answer to my question
2) it would be very good to refer to sheets by name, but, unfortunately, I need to rename some sheets dynamically, don't ask why
Changing the code name works fine in 16.35 for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks