| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to a sheet by (Name) rather than Name from an addin
A sheet has 2 Name properties, "Name", which appears on the sheet tab, and "(Name)"
I want the user to be able to change the "Name" of a worksheet and my code still work. This is no problem if I refer to the sheet using the "(Name)" property, but if I try to refer to the sheet in this way from another workbook then it doesn't work. Can anyone tell me why Book1 contains the sheet: RealSheetName(User's Sheet Name and module Book2 contains module 'My code works in Module1 but not Module Sub Tes MsgBox RealSheetName.Nam End Su |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refer to range in another sheet | Excel Discussion (Misc queries) | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| How can I refer to sheet number not sheet (name)? | Excel Worksheet Functions | |||
| Refer to Previous or Next Sheet | Excel Worksheet Functions | |||
| Refer new sheet to previous sheet | Excel Worksheet Functions | |||
Threaded Mode
