- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi all,
I'm trying to create a rule that will change the Title Block size based on what Border size the user changes to. The default drawing template is a B size, but if the user was to change it to a D size, the Title Block is too small.
This is what I have done so far:
If ActiveSheet.Size Is "A" Then
ActiveSheet.TitleBlock = "TitleBlock Small"
ElseIf ActiveSheet.Size Is "B" Then
ActiveSheet.TitleBlock = "TitleBlock Small"
ElseIf ActiveSheet.Size Is "C" Then
ActiveSheet.TitleBlock = "TitleBlock Large"
ElseIf ActiveSheet.Size Is "D" Then
ActiveSheet.TitleBlock = "TitleBlock Large"
End If
I works, but only if the user manually runs the rule. Is there a way to have it automatically run when the Border changes?
Thanks in advance.
Bob
Product Design & Manufacturing Collection 2025 | Vault Professional 2025
Dell Precision 7670 | Intel i7-12850HX - 2100 Mhz - 64GB
nVIDIA RTX A3000 12GB | Windows 11 Pro
Solved! Go to Solution.
