switching to another window easy

  • Thread starter Thread starter ëïÌó
  • Start date Start date
Hi,
I just wonder if it's so complicate to make ea button to switch to another open book in MS Excel.
Thx
 
If you want to make a button to do this, just go to tools > Macros > record
new macro, name it something descriptive and start recording. Then switch to
the worksheet you want and click "stop recording". Then put a button on the
other sheet, right click it and select "assign macro". Choose the macro you
just recorded an voila! you've got a button to switch worksheets.

....kurt
 
Hi ëïÌó,
hold"Alt"press"Tab",you can switch easily among all open windows
Click to expand...

I think that this switches application windows.

To switch between workbooks try: Ctrl-Tab
 
Back
Top