Hi,
I want my macro on the IR Tracker sheet to run once workbook is opened.
Is this possible?
Please help.
Thanks.
I have attached the workbook for better understanding.
Roma
Hi,
I want my macro on the IR Tracker sheet to run once workbook is opened.
Is this possible?
Please help.
Thanks.
I have attached the workbook for better understanding.
Roma
Re: Run macro once workbook is opened
forum.ozgrid.com/index.php?attachment/48806/
You will see the instructions inside
Cheers
Re: Run macro once workbook is opened
Hi yegarboy,
Not sure why it's not working on my end. =(
Re: Run macro once workbook is opened
You must have Macro's enabled The code I placed is located in the "ThisWorkbook" section. Just under the Sheets in the VBA editor.
Re: Run macro once workbook is opened
yes, I did enabled the macro.
I trying the worksheet that you have attached.
my macro should run once I opened the worksheet but row 27 is still in the IR tracker tab when it should already be in the closed tab (since that's what my macro should do..)
=(
Re: Run macro once workbook is opened
Upload your book with the Macro.
Re: Run macro once workbook is opened
Please see attached.
Re: Run macro once workbook is opened
You want the code placed in WorkSheet_Activate. Not WorkSheet_Change.
Re: Run macro once workbook is opened
Still not working. =(
I have attached the workbook with your macro and my macro moved to WorkSheet_Activate.
I think I am doing something wrong still.
Re: Run macro once workbook is opened
i am getting a runtime error 424 Object required.. =(
Re: Run macro once workbook is opened
Ok, I changed it up a bit. Try this. It run at WorkBook Open. So any changes you make wont show up until you reopen the book.
Re: Run macro once workbook is opened
Thanks. Though it's working already, I just have one more question/request.
Is it possible that all Closed items be transferred to Closed tab at once?
Whats happening right now is that if I have more than 1 closed items, that is also the times I have to re-open the book.
Re: Run macro once workbook is opened
I added a Button next to "Today" called "Transfer". Fill in some dummy data and click it forum.ozgrid.com/index.php?attachment/48918/
Re: Run macro once workbook is opened
So it will still transfer closed items one by one right?
I was hoping that it will transfer all closed items at once.
But thanks a bunch. =)
Re: Run macro once workbook is opened
Weird,
If you input like 5 Closed items it will transfer all but 2. Then if you click it again it transfers them 1 at a time. I cant figure out why its doing that in your book. In my test sheet it works fine. Glad it does work though.
Cheers
Re: Run macro once workbook is opened
I think there is something in my workbook that is causing it.
Thanks anyways. =)
Don’t have an account yet? Register yourself now and be a part of our community!