Switching between active worksheets

 

Past Tip of the Day

 

Matthew asks "Are there any hotkeys for switching between spreadsheet to spreadsheet?"

Sure, a couple listed below:


  • Control Tab or Control Shift Tab: Switch between windows (Or workbooks)
  • Control Pg Down or Control Pg Up: Roll between worksheets in a Workbook.

By Juan Pablo Gonzalez on 04-Feb-2002
MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.