View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] MichaelRLanier@gmail.com is offline
external usenet poster
 
Posts: 36
Default Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet

I have 2 files: FileA and FileB. FileA is an office. FileB is a help file used to explain data in FileA. Both have 10 sheets.

Here is what I hope to accomplish. If I am viewing FileA, Sheet 3, I want to right mouse and have FileB open to its Sheet 3. Likewise, I need this corresponding action for all 10 sheets. I am using Excel 2003. Is this possible? Any suggested macro would be appreciated. Thanks.

Michael