Retrieve layout names by order of which they sit to populate in drawing list on the first page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi all,
I'm wondering if anyone has any ideas on how to call out a layout tab name based on there order onto the first page. This is without using sheet set manager since my co-workers don't know how to use it. The file I'm working on is a template for projects at work.
So I have a drawing list table set up on the first page and I want a code that will take the layout name of the first page (which I understand I can just use ctab) and insert it into the first row. Then the second row takes the layout name of the second page. Then the third row takes the layout name of the third page. And so on and so forth. It can't be specific to one layout, because I want to be able to move the layouts around and for the table to update in the order the layouts are in.
I've looked around quite a bit and it looks like this isn't a simple task and I understand if the best solution is to use sheet set manager. However, I like challenges like these and wanted to see if anyone could come up with something. The closest I've come is retrieving the object layout ID and then using the code to output the name. A couple issues with this: it's specific to the layout and not the order plus I'm stuck at only being able to retrieve the name in code (VBA) but can't insert it as a field. I do think this kind of method is on the right track, maybe.
Thanks in advance.