Macro to create a shortcut to make next Worksheet visible
activesheet.next.Activate
You would have to check that the activesheet is not the last sheet and also
pay attention to hidden sheets.
Also look at the previous command.
--
Regards,
Tom Ogilvy
"nde" wrote:
Hello,
I am looking for a macro that will make the worksheet to the right of the
active worksheet visible, thus enhancing the navigatiuon through the excel
workbook. Once the last worksheet on the right is reached the I will start
again at the first one.
Actually I am looking at the same behavior than the Alt + Tab keys
combination in Windows.
Has anyone done this.
Thanks,
nde
|