run macro question

Hi Mark

The word "Run" in VBA simply tells it to execute the macro whos name follows the word e.g.
Run "MyMacro"
would simply run the macro called MyMacro.

Dave

OzGrid Business Applications

where do I enter the commands ?

Thank you Dave, I guess the better question is exactly where and how do I enter the commands..ActiveWorkbook.Windows(1).Caption = ActiveWorkbook.FullName.

Also would this work if create in the blank wookbook template to work with every new workbook ?

Thanks again

Re: where do I enter the commands ?

Hi Mark

Mark, in your Template, right click on the sheet picture, top left next to "File" and select "View Code" then paste in this code.

Private Sub Workbook_Open()
ActiveWorkbook.Windows(1).Caption = ActiveWorkbook.FullName
End Sub

Dave

OzGrid Business Applications