Andy Pilkington
Board Regular
- Joined
- Jan 23, 2014
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Hi,
Two similar "errors" have recently begun to occur simultaneously relating to blocking of cells.
1 When multiple cells are blocked on any worksheet and I temporarily moves to another worksheet and then return to the original worksheet the blocked text ought to, and used to, remain blocked. However, now when I return to the original worksheet only the top left cell of the block is selected.
2 When use the "goto" function F5 and type in a cell range name, or if I use the drop down option in the Formula bar, to go to a named range of cells on another worksheet I ought to, and used to, be taken the blocked cells in the range name. However, now I am only taken to the top left cell of the range.
The trigger for this may be a "plugin" from another software which was part of an upgrade on that software. How this works I am not clever enough to know but it does give me a new and separate TAB on the Excel menu in the ribon.
I have since removed the software with the plugin and loaded the older version but the plugin tab remains and although I can identify it in the Add-in section in Options I can't delete or disable it. I have attached a couple of images to show what I mean.
Any ideas on how to overcome any of the above please?
Thanks,
AP
Two similar "errors" have recently begun to occur simultaneously relating to blocking of cells.
1 When multiple cells are blocked on any worksheet and I temporarily moves to another worksheet and then return to the original worksheet the blocked text ought to, and used to, remain blocked. However, now when I return to the original worksheet only the top left cell of the block is selected.
2 When use the "goto" function F5 and type in a cell range name, or if I use the drop down option in the Formula bar, to go to a named range of cells on another worksheet I ought to, and used to, be taken the blocked cells in the range name. However, now I am only taken to the top left cell of the range.
The trigger for this may be a "plugin" from another software which was part of an upgrade on that software. How this works I am not clever enough to know but it does give me a new and separate TAB on the Excel menu in the ribon.
I have since removed the software with the plugin and loaded the older version but the plugin tab remains and although I can identify it in the Add-in section in Options I can't delete or disable it. I have attached a couple of images to show what I mean.
Any ideas on how to overcome any of the above please?
Thanks,
AP