I have an application where I need to change the behavior of the objects on a sheet given the name of the sheet to avoid having to code the date logic in every single sheet /sheet object. Each sheet is named for a week of the year, and all the sheets have identical controls except that the date logic needs to know what sheet they are on so that the data displays for that week on that sheet.
Note: GetActiveSheetID() won't work since the chart objects on each sheet need to access their parent, not the active sheet.
Any thoughts?