Automatic Execution of Macros

[#27 with Blackbean Sauce]

I am doing an assignment and need to have a macro that will update every time the spreadsheet is opened, and if possible(doubtful) that will run when new data is entered into the spreadsheet. As far as I know this cant be done with manual execution(with a button) or shortcut keys. If anyone can help me out it would be much apreciated.

Thanks.

#27

 

[plettieri]

This might help for the fisrt part of yr question...taken from a prior post by Kevin


you can do this in either one of two ways:

1. write a macro and name the macro auto_open. the macro will run automatically when the file is opened.

2. place the following code in your 'this workbook' object window in VB editor:

Private Sub Workbook_Open()
'place your code here
End Sub

either of these methods should work


pll

 

[#27 with Blackbean Sauce]

cheers

 

[Mudface]

Also, use the Worksheet_Change (or Calculate) events to run code when the contents of the worksheet change.