ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   mag-keyboard shortcut (https://www.excelbanter.com/excel-worksheet-functions/20709-mag-keyboard-shortcut.html)

68magnolia71

mag-keyboard shortcut
 
Someone in the discussion group who knows a shortcut to toggle between two
sheets in the same file, Ctrl+??? (sorry no VBA)

67magnolia71

ww

You can use Ctrl+Page Up or Ctrl+Page Dn to switch betweeen tabs in a
worksheet if that's what you mean.

"68magnolia71" wrote:

Someone in the discussion group who knows a shortcut to toggle between two
sheets in the same file, Ctrl+??? (sorry no VBA)

67magnolia71


David McRitchie

Another way is with a hyperlink, you can use the BACK button (alt+arrowLT)
to return. By restricting yourself from VBA you may be limiting yourself.

I think if you have something in mind that you really want to do, that you
will probably have to use VBA. If you want to build your own short cut
keys you will need to use code, either code under your control or
an addin.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ww" wrote in message ...
You can use Ctrl+Page Up or Ctrl+Page Dn to switch betweeen tabs in a
worksheet if that's what you mean.

"68magnolia71" wrote:

Someone in the discussion group who knows a shortcut to toggle between two
sheets in the same file, Ctrl+??? (sorry no VBA)

67magnolia71





All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com