Worksheet Name in Worksheet?

[MattG]

This is probably a simple one and I cannot believe I have not thought to do that in the past.

 

Is there a function I can put in a worksheet to display the worksheet name?  I'm not finding that. 

 

Thanks,

Matt

[michaelk]

Matt, that is such a great question.

 

I think the answer is no.  Even with a script that runs from the worksheet cell, I don't think you can do it.  I hope someone proves me wrong 🙂 .

 

 

[MattG]

I'm really surprised if that is the case and also somewhat surprised it has not come up before. 

 

I am making a bunch of very similar worksheets that are sorting info from different locations.  I am hoping to have a cell at the bottom that just says what the worksheet name is for reference to be sure I got the right one.

[michaelk]

I have had this thought many many times as I typed in the name of the worksheet into a cell.

 

Request it!

[kinglevel]

+1

 

This would be very great 

[Silvano Mainardes]

Try it:
1. Select the name of the worksheet on the resource manager and copy it.
2. Place this worksheet in the drawing.
3. In the OIP of this worksheet, paste the name on the Name field and add a number, a caracter or resume it.
4. Clic twice on the worksheet in the drawing.
5. Clic on an apropriate cell for the name and type:
=Name(sel=true)
Clic the checkmark.

[Pat Stanford]

@Silvano,  Nice find, but it is fragile. It only works because when you are selecting to recalculate the worksheet you have it as the selected object.

 

Try this. Repeat your steps above and create a second worksheet with a different name.

 

Right click on either of the worksheets and choose Recalculate All Worksheets. Notice that the Name field in both worksheets is replaced with the name of the worksheet that you clicked on.

 

Also, this is not the name of the worksheet, it is the name of the worksheet image. If you rename the worksheet in the Resource Manager, the name in the OIP does not update.

 

If you recalculate from a script like in the following thread. You could have any object in the drawing selected and get the name of that object instead of the name of the worksheet image.

 

 

If this works for you in your application that is great, but this is not nearly robust enough for me to use as a general purpose solution for what I am trying to do.

[Silvano Mainardes]

Oh, sorry for the glitch, I didn't use recalculate all sheets because I had a slow processor before and now I haven't tested enough. We learned a little more from you today.
Thank you Pat Stanford.

[Bruce Kieffer]

I ran into this "wish" today. I'll add it to the wish list.

[SLFY]

I will add this as a "wish" too. InteriorCAD will generate cabinet part information into worksheets, and each worksheet is named to include the cabinet "name". But the worksheet name is the only place the cabinet name appears, and I can't find a modification to the InteriorCAD worksheet layout that will add it to a cell. A head scratcher since, obviously when I print out those sheets, the cabinet name is lost and I have a piece of paper with a lot of what would be valuable information for the cabinet maker if we knew what cabinet it was for. I thought a simple solution was to add a cell formula to the template that displays the worksheet name...and then I found this thread. Sigh.