Thread: Chart pop-up
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henk Frigge
 
Posts: n/a
Default Chart pop-up

John,

The trick is that I use frozen windows, so the command buttons are alway up
in the upper left corner of the screen. Down-right I am working with my data.

I always used Sheets.Select to change from the one sheet to the other, but
then you always return to cell A1. In your FlipFlop routine, you used
Sheets.Activate and I noticed that you than return to the sheet in the same
way as you left it.

Simple as that! In other words : It works perfectly.

Many thanks for helping me out.

Regards,

Henk