access to the document shapesheet

Started by ghenders, November 19, 2012, 01:24:10 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ghenders

I don't see any documentation on this, so maybe I'm doing something wrong.  I'm trying to use the "User-defined Cells" section of the document's shapesheet to store some persistent values.    I know how to access the shapesheet for shapes and pages, but I'm not having any luck with the document shapesheet (is it read only?).  Any suggestions on VBA I can use in a userform to read / write to those cells?  Or are there better ways to store persistent global variables?

AndyW

To access the document sheet user cells, 'TheDoc!User.yourcell'
Live life with an open mind

aledlund

the doc sheet for documents (and pages) can be accessed the same way as shapes

    Dim docSheet As Visio.Shape
    Dim visDoc As Visio.Document
    Set visDoc = Application.ActiveDocument
    Set docSheet = visDoc.DocumentSheet
    ' do something with the document sheet

    Dim pagSheet As Visio.Shape
    Dim visPage As Visio.Page
    Set visPage = Application.ActivePage
    Set pagSheet = visPage.PageSheet
    ' do something with the page sheet

al

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 166 (show)
Files included: 34 - 1321KB. (show)
Memory used: 1115KB.
Tokens: post-login.
Cache hits: 12: 0.00191s for 26,582 bytes (show)
Cache misses: 1: (show)
Queries used: 18.

[Show Queries]