|
|
Thread Tools | Display Modes |
#6
|
|||
|
|||
Hi, I alter my statement, it doesnt work,
At right I have a sheet for monthly income from investments delivering such, at left I want the sheet showing annual incomings outgoings, from where I will source that data. At left I click the link in the index page for annual IN OUT 2022, and horror, the right hand one becomes that sheet. How do I make the click on sheet link alter the window the click is made in, and not alter the window at right ? They are one of the same workbooks. The old method had a read only and one could do this above and it only operated on the left workbook, it didnt keep altering the sheets at right. If this is Excel thinking they will make changes for the better, this is a nightmare, links in left workbook alter sheets in right workbook. So is there a way to limit the action to just the left workbook when I click on the hyperlink in that workbook to the sheet in the index page ? DBenz |
Tags |
read only |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2010 Excel attachments from mail open in Read Only mode | remi | Outlook | 0 | 08-09-2016 06:50 AM |
Autofill SaveAs File Name box using read only workbook | newbieX | Excel Programming | 1 | 05-20-2015 11:16 PM |
Can't open 2010 ics calendar file in 2013 | JuanMunito | Outlook | 0 | 12-02-2014 09:06 AM |
ThisAddIn.Application.Documents.Open() methods opens new word instance even though the active docume | chetan rajakumar | Word VBA | 1 | 08-23-2014 03:52 AM |
Open new instance for each file | a3ng25 | Office | 1 | 01-28-2013 06:47 AM |