The first thing you need to do is use the record feature to record the steps that you want your macro to take. Once you have that, create a userform with a couple buttons to put that code with.

Lastly, once you have the userform created, create a new sub called AutoOpen(). In that sub put "Userform1.Show" (or whatever your userforms name is). Whenever that document is opened, that userform will initiate.