Macro to navigate between worksheets

This is one way to achieve your request:

Please Login or Register  to view this content.

Dear luxy007

Its a bit difficult to know what you want to move but you can make a loop in VBA and use this either in the top or the end of the loop;

Please Login or Register  to view this content.

The macro will then be running all the time until you define something that get it out of the loop. The problem with this solution, I think, is that you can't work in the workbook as long as it is running. Maybe other can help here.

As per Ipsenh suggests...This will loop through the visible sheets every 30 seconds until you cancel

Please Login or Register  to view this content.

apply this code to ThisWorkbook :

Please Login or Register  to view this content.

Then add this code to a module

Please Login or Register  to view this content.

Originally Posted by luxy007

Hi PFDave.

You are really and truly an Excel Ninja!!!!

And thanks, I appreciate all feedback

Hi PFDave,

So sorry to bombard you with many questions. I am quite new to the world of VBA.

Do i make the code like this when i add it to the module?

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Edit your previous post to add the code tags, please - do not create a new post instead!