Re: IV 2017 Carsh when selecting OBJECTS DEFAULTS tab We believe this was fixed with the Inventor 2017 R2 release. Since we were never able to reproduce the issue, we can't say definitively that it is fixed, but we made code changes and there have been no crash reports submitted for this issue from anyone using the 2017 R2 release.
Issue:
You want instructions on how to cycle through objects that are overlapping in an AutoCAD drawing.Causes:
The process to cycle through objects that are overlapping in AutoCAD has changed over time. Depending on the version you are using, there are different workflows.Solution:
Legacy behaviorIn AutoCAD 2006 and previous versions, you can cycle through the selection of overlapping objects by pressing CTRL+click. You can set the LEGACYCTRLPICK variable to 1 to restore using Ctrl+click to select overlapping objects:
- On the command line, type LEGACYCTRLPICK and press Enter
- When prompted to enter a new value, enter 1. Note:After you make this change, you will not be able to select subobjects of 3D solids by pressing Ctrl+click.
- To change the behavior back to the default behavior of AutoCAD 2007 and later, set the variable to 0.
In AutoCAD 2007 through AutoCAD 2010, the key combination to cycle through the selection of overlapping objects changed:
- At the Select Objects prompt, hold down the Shift+Spacebar and click as near as possible to the object you want.
- Keep clicking until the object you want is highlighted.
- Once the object you require is highlighted, press Enter to select the object. Note: If selection preview is turned on, you can cycle through the objects by rolling over the object on top to highlight it. Press and hold Shift, and then press the Spacebar continuously. When the required object is highlighted, left-click to select it.
In AutoCAD 2011 through the present release, the Selection Cycling dialog box was added.
- At the command line, type DS (Drafting Settings) and press Enter.
- In the Drafting Settings dialog box, click the Selection Cycling tab.
- Select 'Allow selection cycling' and click OK.
See Also:
About Cycling Through and Filtering SubobjectsSelection Cycling Tab (Draft Settings Dialog Box)
Products:
AutoCAD; AutoCAD Architecture; Civil 3D; AutoCAD Electrical; AutoCAD LT; AutoCAD Map 3D; AutoCAD Mechanical; AutoCAD MEP; AutoCAD P&ID; AutoCAD Plant 3D;Active2 years, 8 months ago
It's really annoying that Excel (2003 and 2007) doesn't show what cell, rowor column that is selected when the window is not in focus. I typically want torefer to the current cell or row while working in another application.
Is there any workaround or fix that will make the cell/row highlighted when not in focus?I know that you can copy a cell (Ctrl+C) but it's kind of tiresome to do that every time.
sallesalle74211 gold badge99 silver badges1212 bronze badges
7 Answers
I think there is a work around but, it really depends on your situation!
You can create a macro which fires when the selection changes and it simply changes the background of each cell. When you 'leave' the cell it will reset the row's background value to white and then select the new row.
I added this to my Sheet1 in the Visual Basic window.
This screen shot was taken while the application had lost focus.
This may be annoying but you could easily add a button which could toggle this feature on or off!
The negatives are (from top of my head : It will remove any current highlighting you have. So if you have highlighting on your page (cells coloured) then best not use this! Also, it will probably print with the highlighted rows!
DaveDave23.7k99 gold badges4646 silver badges6565 bronze badges
You can do something like this if you need to. Although it might be sheet specific
This changes what is not active back to white, and changes the activecell to yellow. and still shows when the window is not active.Not sure this is the best way, but it works
datatoodatatoo
Here is a modification of the code from @datatoo. It reads the previous values to prevent losing the current fill color. It also changes the text color to make it further stand out. I added it to the Excel sheet in the code editor (Alt-F11 from Excel).
Click here for information on making a worksheet change event.
bstrongbstrong
Use a shape to highlight the selection.
Note: It works only when switching to another Excel window. As a workaround you can open an empty Excel window and switch to this window before switching to another application to keep the highlight.
Just add this to your ThisWorkbookcode (your workBOOK, not your sheet´s code).This will work for every sheet in your workbook.
You can even format the shape to your preference by tweaking the code.
The advantages are:
- you don´t lose your original formatting when excel crashes of you have a power failure
- You don´t lose your original formatting when using CTRL+[ from another workbook that changes the active sheet
- You don´t lose the highlight when making changes to the other excel window while compared to the CTRL+C solution
cyberponkcyberponk
In Excel 2003 the currently selected cell address is shown in the upper left. Although the cell isn't highlighted, it gets you partway there.
MichaelkayMichaelkay
there is no permanent solution to this problem.
a workaround (may get annoying in a while) would be to change the highlighting of the selected cells while they are selected and re-select them again to drop the color.
Stick this code in Sheet1 code behind and go to you spreadsheet and select some cells, select other ones then re-select the first ones to drop the color
user222864
In a standard module:
In the sheet(s) you want it to work in:
In
Citations: The simple solution is based off of a previous answer by @Dave; The complex solution was brought together from many sources, especially with the help of @JohnColeman in this post.ThisWorkbook
:Community♦
Travis HeeterTravis Heeter29811 gold badge33 silver badges1616 bronze badges
protected by Community♦Oct 29 '15 at 20:13
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?