| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does a Multi-sheet/user file open on sheet two every time? | Excel Discussion (Misc queries) | |||
| How to consolidate 580 file's data in 1 sheet without oppening all | Excel Worksheet Functions | |||
| my file's format changes when i open the file on another computer | Excel Discussion (Misc queries) | |||
| Lookup on a sheet so that every time when file open it copes data from another file sheet | Excel Programming | |||
| shortcut to open file in personal.xls blocking file's macros | Excel Programming | |||
Threaded Mode
