ExcelBanter - Write Code w/VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Write Code w/VBA (https://www.excelbanter.com/excel-programming/362217-write-code-w-vba.html)

Ronbo

Write Code w/VBA

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards

Tom Ogilvy

Write Code w/VBA

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Ronbo" wrote:

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards

Ronbo

Write Code w/VBA

Thanks, that is exactly what I was looking for.

"Tom Ogilvy" wrote:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Ronbo" wrote:

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards

All times are GMT +1. The time now is 12:10 PM.