A tool for getting a reference to a ShapeSheet's cell

Опубликовано: 25 Сентябрь 2026
на канале: Surrogate I
527
like

With this tool, you can refer to a cell in a shape's property table, including a shape on another page.

0:00 Introduction
0:24 Why do we need shape links?
1:07 Shape cell reference syntax
1:28 Cell name in ShapeSheet
2:00 How to copy a cell name in a properties sheet
3:31 Problems defining page and shape names
4:05 Mentioning the "Local and Universal Names in ShapeSheet" video
4:15 Description of the reference tool
5:41 Getting a formula to paste into the Immediate window
5:51 Opening a VBA editor window
6:00 About the Immediate command line window
6:18 Getting a shape reference
6:35 Pasting a received reference into another cell
6:54 Get a reference to the same property but on a different shape
7:29 About links to figures on the same page
7:50 How to get links to properties on a page
8:30 Conclusion

The actual tool you describe is available here:
https://surrogate-tm.github.io/snippe...

Information about cell references:
https://docs.microsoft.com/en-us/offi...