Need To Move Sheets With Some Criteria!

[Rajeshkumar R]

Hi Friends,

Now, I am quite familiar with Excel Formula & Functions and hope it’s a time to move on to next level like VBA. Please do suggest me what would be the easiest way to learn the same.

Kindly note, as of now VBA means it is “Visual Basic for Application” that much only I know! Not more than that &

At Present, I need your immediate help to achieve below task:-

Please open attached file, which has 9 Summary Sheets and 3 working Sheets which is input to those summary sheets.

When I display this file on a computer, I want below necessities to be taken care.

1. Sheet has to move from Left Side to Right Side i.e. starts from Sheet “AAA”
2. The time delay to move from one sheet to another sheet should be 60 Seconds, means each summary it has to display for 60 Seconds.
3. Each Summary Sheet has to keep display till it reaches Sheet “III”, i.e. nothing but last summary sheet, then again it has to start display Sheet “AAA” and keep repeat the same thing.
4. It should not display working Sheets or other any sheets which is there in the same File.
5. I need a button in Sheet “AAA”, once I click that VBA will starts work and again click the same it has to stop its activity.

Looking forward quick updates from your end…

Thanks & Regards,
Rajeshkumar R

[Rajeshkumar R]

High Priority!

[antoka05]

See attached file where I added this code in a module.. I hope it's what you need:

Please Login or Register  to view this content.

Regards,
Antonio

[Rajeshkumar R]

Hi Antonio,

Thanks a lot, I got the output exactly what I need...

Thanks & Regards,
Rajeshkumar R