Run a Macro just after i open a workbook EXCEL

  • Thread starter Thread starter mkparasar
  • Start date Start date
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
 
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

How to apply a macro to all workbooks 2
automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
Button looses Macro setting when running Macro 1
Run code from another workbook 7
a macro that runs automatically when a workbook is opened 2
Macro for all Excel Workbooks to print to PDF 2
conso macro 0

Back
Top