How to delete multiple checkboxes in excel

Go To command can select many types of control including the checkboxes, if your worksheet has only checkboxes control object, the method can help you select the multiple checkboxes and delete them at once.
1. Click Home > Find & Select > Go To Special, and a Go To Special dialog box will appear. See screenshot:

2. Then choose the Objects option from the Select. Click OK.
3. And all of the checkboxes have been selected, and then press Delete key on the keyboard.
4. All of the checkboxes will be deleted.
Note: If there are other objects in the same worksheet, this method will delete them as well.

Again, you can delete multiple checkboxes with VBA code
The following short VBA code also can remove the multiple checkboxes. Please do as the following steps:
1. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module:

Sub RemoveCheckboxes()
On Error Resume Next
ActiveSheet.CheckBoxes.Delete
Selection.FormatConditions.Delete
End Sub

2. Then click button to execute the code. And all of the checkboxes have been deleted.

Resource: http://www.extendoffice.com/documents/excel/877-excel-delete-multiple-checkboxes.html

Insert diameter into line tage number

 

Basic formular:

 

Most convinient formular:
=SUBSTITUTE(A1,"-","-"&B1&"-",3)

How to search content in excel files (without open the files)

Sometimes, we do need to know if we have submitted the particular issue (some word, or numbers) in whole bunches of files. but we can not open the files one by one.
Through Google, a gentleman share his great idea.
I organized by my understanding, and wrote the follow steps:

1) open a file folder

2) click "tool"

 

3) click "folder option"

 

4) click "search", then "always search file names and contents".

5) click "ok".

Now, go to windows explor, click "start", then type the drawing number you're searching for.
See what's happen.

 

 

 

Drawing Scale Changed

One day, you may find the pipeline what you put on which was on grid. but is moved over night. There could be Admin. did something, or... something we don't know. Let's talk about the solution: At first, check the other "good" drawing's scale. Go to View--Property--Grid, then write down the scale number. see the attached picture. Then, go to your drawing which all lines moved. match the scale with the good one.

ORA-00018 maximum number of sessions exceeded

ORA-00018 maximum number of sessions exceeded Cause: All session state objects are in use. Action: Increase the value of the SESSIONS initialization parameter.Reference: Oracle Documentation ORA-00018 comes under "Oracle Database Server Messages". These messages are generated by the Oracle database server when running any Oracle program. How to increase SESSION initialization parameter: 1. Login as sysdba sqlplus / as sysdba 2. Check Current Setting of Parameters sql> show parameter sessions sql> show parameter processes sql> show parameter transactions 3. If you are planning to increase "sessions" parameter you should also plan to increase "processes and "transactions" parameters. A basic formula for determining these parameter values is as follows: processes=x sessions=x*1.1+5 transactions=sessions*1.1 4. These paramters can't be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance. sql> alter system set processes=500 scope=spfile; sql> alter system set sessions=555 scope=spfile; sql> alter system set transactions=610 scope=spfile; sql> shutdown abort sql> startup Related Links: ORA-00054: resource busy and acquire with NOWAIT specified http://nimishgarg.blogspot.in/2012/05/ora-00054-resource-busy-and-acquire.html ORA-00020 maximum number of processes exceeded http://nimishgarg.blogspot.in/2012/05/ora-00020-maximum-number-of-processes.html Original Article

OPC text missing the position

There is an interet thing happy since last week.

the "..." control the directiong of the OPC. after I changed it to left. the text missing position.

Put a new one, same thing happed.

Site Server Permition_SPPID Installation

I finished Whole process of SPPID installation. and it works well. but after I shared my remote computer with my co-workers, I found they can not open the drawings.

After asked the master, I know there is one more step need to do: right click your Site Server. then click the permissions. add your co-worker's name on it. then refresh the role in Engineering Manager. It work!

The logic is clear: your co-worker need permission to access the reference files. Otherwise, they only can connect with server but doing nothing.