MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I get a Macro to Auto Run?


Posted by Donald A Barron on June 29, 2001 9:22 AM

Probably an easy question for most of you but I truly don't know how and I have become frustrated. Can any of you help me?

Thanks!

Donald


Posted by Ben O. on June 29, 2001 9:27 AM

Name the macro Sub Auto_Open() or Private Sub Auto_Open(). It will run automatically when you open the spreadsheeet.

-Ben

Posted by Donald A Barron on June 29, 2001 10:14 AM

No luck. This is what I am trying to do.
Using VBA, I want to AutoRun at startup this command to all my spreadsheet.

Sub EnableAutoFilter()
ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
End Sub

Can you still help me? Thanks for the reply.

Donald

Posted by Donald A Barron on June 29, 2001 10:16 AM

No luck. This is what I am trying to do.
Using VBA, I want to AutoRun at startup this command to all my spreadsheet.

Sub EnableAutoFilter()
ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
End Sub

Can you still help me? Thanks for the reply.

Donald