Makro button to switch pages

  • Thread starter Thread starter Royor
  • Start date Start date
R

Royor

Guest
I would like to have a macro button on the screen that, each time I click on it, it would take me one sheet further. Eg., from sheet1 to sheet2 to sheet3 and so on.
The use of a macro button is that it stays visible at the same spot on the screen, so that's easy.
I guess it's only one line in VB code, something like "Activesheet+1" or so, but I can't find the right syntax to make this work.
Any help greatly appreciated
smile.gif
 

Users who are viewing this thread

Back
Top Bottom