Getting rid of a button

[Kipster1203]

This should be easy for some of you! I have a button that when clicked goes to a certain macro code. I need to get rid of the button so how do I get the code to run once when the file is opened?

 

[ljungren13]

Double click on ThisWorkbook and paste this:

Private Sub Workbook_Open()
Call YourMacroName
End Sub

Then change "YourMacroName" to what ever the macro is named that you already have assigned to the button

 

[Sahak]

Hi Kipster,

1. Copy
Private Sub Workbook_Open()
Call YourMacroName
End Sub

2. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
3. Right-click on the ThisWorkbook object, and choose View Code
4. Paste

 

[ljungren13]

Workbook_Open will happen if the workbook is opened manually or via code (from another workbook). It should be put in ThisWorkbook.


The Autpen will only run when the workbook is opened manually and should be put into a Standard Module.

 

[Sahak]

Im sorry,

1. Copy

Private Sub Workbook_Open()
        Call YourMacroName
    End Sub

2. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
3. Right-click on the ThisWorkbook object, and choose View Code
4. Paste

 

[Kipster1203]

Here is what it looks like

http://i27.tinypic.com/zjdz45.jpg

As you can see the macro code is under module1

What I did is double click on ThisWorkbook and wrote this code in

Sub auto_open()

Call cell_Color

End Sub


which is obviously wrong since it's not working...

 

[ljungren13]

read my post above about the difference between auto_open and workbook_open... the auto_open goes into a standard module

So paste:
Sub auto_open
call cell_color
End Sub

above "Sub Cell_Color()"

or leave what you have and change "auto" to "Workbook"

 

[Kipster1203]

Thank you so much, that worked!

 

[Kipster1203]

I'm having a weird issue with this... This excel file can be opened from my Access program by clicking a report button. What you guys helped me with works fine when double clicking on the file itself (in the windows folder), however when opening the file using that Access button, the file opens but the auto open function doesn't work! I can't figure out why.... any ideas?

 

[Kipster1203]

I'm thinking about maybe using a worksheet or workbook event, so that the code is run when the worksheet or workbook is activated.... but haven't been able to get that to work yet.

 

[Kipster1203]

Still trying to get that to work, someone help!!!!!....