Select the ProE default options without clicking

Most ProE users may know this. This one is for those who missed out.

In ProE, the Middle (Scroll) Mouse Button acts like a Default selection.

In most commands of ProE, you will find one option in Bold. The straight forward option is to go there and click it. But pressing the middle button will select the default option automatically. You do not have to move the mouse at all. This also applicable in many Dashboard Commands and other like File-Open.

Save your precious time ! If you have not used it, get used to it now on.

Footnote:
You can configure ProE to have your default option changed as well.. Thats another post coming later..

Comments

Proe Function / Relation to round the decimal places

Its strange that ProE does not have a ROUND function. At least I counldnt find it. It has two funtions. Ceil will always round it up. Floor will always round it down. I have used both to get the ROUND functionality. here is the relation...

[ Read more » ]

TreeView Structure in Excel VBA

TreeView is extreamly useful in specific cases but it can be bit tricky sometimes to implement. Last Few days I was working on a TreeView Structure and thought I will share the knowledge I gained... This post takes you through the basic operations to create and operate a TreeView. It will be like the Folder tree window of the windows explorer. Moreover, you can have it dynamically updated based on the data in excel.... Here we go..

[ Read more » ]

Color the Excel row based on a value/status

Very often, we would like to differenciate the rows that are having certain status (or specific values in a specific column) in a different color. We can filter for the status and apply the color manually, but we can also do that dynamically or automatically with a specific tweak to the Conditional Formatting feature in Excel

[ Read more » ]

Tips by Joe (Proe, Excel...)

Search This Blog