I've leveraged some help posts here to put together a macro to update drawing sheet format for a single file (not opening silently), but the SetupSheet5 Method requires the user to click "OK" to continue no matter what I try.

EDIT: SetupSheet5 and SetupSheet6 produce the same behavior.

EDIT: Opening the file silently produces the same behavior.

Code:

Result (popup appears on each sheet update):

Test drawing & format: