Getting macros to auto run

[crjaynes1]

Hi,
I am fairly new to VBA and macros in Excel. I am writing a program to help keep automate a process in our office. I am using a series of input screens. I tried to keep in mind that everyone may not use 21 inch monitors so tried to keep the "real estate" input area to a minimum. Unfortunately, on some smaller screens the input area bleeds off the screen. I have a macro that will size these input areas to fit whatever screen size is viewing the program, but apart from attaching this macro to a button and saying click here to resize, is there a way to have this macro automatically run when this workbook is opened. I have copied it into the personal.xlsb workbook but don't know how to tell it to aytomatically run. Any ideas if this is possible.
Thanks

 

[jasonb75]

Use the workbook_open event, i.e. rename your procedure,

Private Sub Workbook_Open()
 
' your code here
 
End Sub

This must be in the "This Workbook" module, not a regular module.

http://www.cpearson.com/excel/Events.aspx

 

[crjaynes1]

Jasonb75, Thank you for the response.

 

[crjaynes1]

jasonb75, got it to work, took a little effort, didn't realize that the code had to be copied into the thisworkbook module in the VBA editor, I was initially just saving it as a macro in workbook. Thanks, that is a big help being able to resize the different input pages depending on who opens. I opened on 17 inch screen, everything fit, sent to my IT guy, he opened on 15 inch screen, everything fit. Thanks again.
Randy