Here is my dilemna.
I have an excel spreadsheet that has conditional statements and lookuptables that will automatically put the correct tolernaces in the drawing format depending on two custom properties (part type PRP@type and drawing units PRP@Units) I've created in the Custom Properties tab for a drawing template.
The spreadsheet works awesome and I've embedded it into the drawing format. The only problem is, in order to change the tolerances, the user has to click on the embedded spreadsheet in the drawing. This is not a problem. The problem is, the user don't realize they have to do this. They are looking for a custom property called "PART TYPE" and "UNITS" for which I've created drop down lists for in the CUSTOM Properties Tab.
How can I LINK these 2 custom properties to cells in my embedded spreadsheet so they will change the drawing units and place the correct tolerances? See attachment
SolidworksApi macros