Yes, you can use VBA to bypass many of Excel's dialogs, including the properties in the format axis dialogs. Whether it is worth the effort depends on why you are trying to bypass the dialog (usually because you will need to frequently change the axis scale properties). In this case, if I understand, it seems like you would need to format the axes once and then never need to change them again, so it seems like more work than necessary.
This tutorial discusses the idea:
https://peltiertech.com/link-excel-c...lues-in-cells/ Note the link at the end to another tutorial that offers a different VBA approach.
Bookmarks