ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Run macro automatically on opening of worksheet (https://www.excelbanter.com/excel-worksheet-functions/71408-run-macro-automatically-opening-worksheet.html)

bnkone

Run macro automatically on opening of worksheet
 
I have a macro I would like to run automatically when the worksheet is
opened. I know I have done this long ago but I don't remember how I did it.

Any ideas out there?

L. Howard Kittle

Run macro automatically on opening of worksheet
 
In the ThisWorkbook code module:

Private Sub Workbook_Open()

End Sub

HTH
Regards,
Howard

"bnkone" wrote in message
...
I have a macro I would like to run automatically when the worksheet is
opened. I know I have done this long ago but I don't remember how I did
it.

Any ideas out there?





All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com