Thank you for the reply, Ive just started to look into scripting. I understand worksheets/ functions and have made a number of intelligent worksheets for the company.
However i am not sure which scripting language to start with? Any recommendations? Ive tried to look on the forums for the answer yet nothings come up.
As for the "User proofing" im starting to understand what you mean. So i wrote a statement to use as a method to work to.
Statement as follows;
Search selected 'Worksheet' for 'Database headers'
Select 'Layer' (Message box shows - drop down box which shows all current layers within Vectorworks document.)
Store [Inputted Layer]
Search for first 'Database header' criteria
If 'Database header' contains 'Layer' Criteria
Then, If layer is different to [Inputted layer] replace layer criteria with [Inputted layer]
Else, move to next "Database header"
Once all "Database headers" have been checked
Message box "Worksheet database criteria amended"
Click 'OK' to end script
I am hoping this is the right simple logic to start with. Thank you again.