a quick problem. im not too sure how to do this
anyways.. i'll give you a quick example of what im trying to do.
okay i want to make some quick formulas but i dont want to use the sheet name like it normally does. and i need to make it function while cells are protected so it cant be a vb script. okay for short.
you have a sheet name.. then you have its actual name.
one is visible.. and the other is only visible when you go into properties.
anyways the visible sheet name needs to be loose as it will potentially change with some of my other scripts. so when i reference a cell in vb i use the actual sheet name instead of the visible name.
now all i need to know is how i can reference the actual name in a excell script.. like for example
with the visible name i would call something from the sheet using somethin like
=sheet1!C1R1
does anyone know how i can do it using the properties name ?
any help would be helpful
ta
anyways.. i'll give you a quick example of what im trying to do.
okay i want to make some quick formulas but i dont want to use the sheet name like it normally does. and i need to make it function while cells are protected so it cant be a vb script. okay for short.
you have a sheet name.. then you have its actual name.
one is visible.. and the other is only visible when you go into properties.
anyways the visible sheet name needs to be loose as it will potentially change with some of my other scripts. so when i reference a cell in vb i use the actual sheet name instead of the visible name.
now all i need to know is how i can reference the actual name in a excell script.. like for example
with the visible name i would call something from the sheet using somethin like
=sheet1!C1R1
does anyone know how i can do it using the properties name ?
any help would be helpful
ta