I am building an add-in that gives my users different functions if they are using different types of worksheets that the add-in creates. But, I need a better way to check if the worksheet they are using is valid for these functions. Right now, I put a word in the BA1 cell that the users see. But, if they delete a column, it no longer works.
I found the document properties and that would work if I could tag specific worksheets, but I don't think I can. If I can access the (Name) property that is shown in the VBA Editor, where most sheets get named Sheet1, Sheet2. I can probably make that work, but I can find out how to do that either. There is the worksheet Name property that is the same as the name that shows up in the bottom tab of a workbook. But, I am thinking the (Name) field that is in the VBA Editor properties window.
Thanks in advance, any help is GREATLY appreciated!
I found the document properties and that would work if I could tag specific worksheets, but I don't think I can. If I can access the (Name) property that is shown in the VBA Editor, where most sheets get named Sheet1, Sheet2. I can probably make that work, but I can find out how to do that either. There is the worksheet Name property that is the same as the name that shows up in the bottom tab of a workbook. But, I am thinking the (Name) field that is in the VBA Editor properties window.
Thanks in advance, any help is GREATLY appreciated!