Reply to thread

Message: [QUOTE="Gord Dibben, post: 3271447"] Toggling 15 Windows hidden/unhidden depending upon d-click on a cell is too much time and effort right now. I will suggest you have a look at the Formula Auditing features of Excel. Specifically the Trace Precedents and Trace Dependents. When you enable trace precedents arrows you just double-click on the arrow and Goto dialog box pops up. Select the precedent or one of the precedents if multiple and OK. Now you are on a precedent cell and can edit that cell. Show trace dependents arrow and d-click on arrow to get Goto dialog box. Pick dependent and OK. Now you are back to original formula. You can also utilize the Watch Window to see results changing as you alter formula precedents. Gord [/QUOTE]