Run a Macro just after i open a workbook EXCEL

M

mkparasar

Hi Guys,

i want to trigger a macro just after i open my workbook in EXCEL with
the condition that if value of cell B1 is equal to todays date trigger
the macro and written the below code.

Private Sub Workbook_Open()
MsgBox Date
If Worksheets("Sheet1").Range("B1").Value = Date Then
My_Macro
End If
End Sub

But it does not seems to be work.

Any advice or help will be appriciated.

Thanks

KAKA
 
D

Dave Peterson

What's in B1?

If you have date and time, you'll have to ignore the time:

If int(Worksheets("Sheet1").Range("B1").Value) = Date Then

Did you put the procedure in the ThisWorkbook module?

Did you allow macros to run?

Were events enabled when you opened the workbook?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Run code from another workbook 7
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Checking if a workbook is open 7
Workbook reminder 0
Opening a list of Excel files and run a macro in each 17
Run macro on all files in a specific folder 3
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top