Excell                                          
*     Microsoft Stuff          
  3/28/23   Excell          
                                             
   
  Home Range(Cells(3,1),Cells(r,22)).Select Customise quick access toolbar
  How To's Save
  Misc Advanced  Document Properties  undo
  Networking Excell 2021    ----> File  >  Info  >>>   Properties (at the top, righthand side)    redo
  Windows    >>>  drop down arrow  >> Advanced Properties Advanced Document Properties
  Glossary Advanced Properties   --->   summary tab Dark Shading
  Excell Light Shading
  Examples Hyperlink Base: when updating a hyperlink base, you must exit the spreadsheet No Border
  Outlook (and/or  the excell application ), for the new hyperlink base to take effect. Outside Borders
  Paint Shop Pro Bottom Border
  Skype To show the Developer tab for Microsoft Office 2010 applications Top Border
  WSH 1. Start the application. Left Border
  DOS 2. Click the File tab. Right Border
    3. Click Options. Calculate Now (F9)
    4. In the categories pane, click Customize Ribbon.
    5. In the list of main tabs, select Developer. X Setting Colors in Excel VBA Macros (#macros) R G B
    6. Click OK to close the Options dialog box. 255 222 117  
    ActiveCell.Borders.Color = RGB(255, 0, 0) 192 192 192  
    To show the Developer tab for Word 2007, Excel 2007, and PowerPoint 2007 ActiveCell.Borders(xlTop).Color = RGB(0, 0, 255) 206 114 112  
    1. Start the application. ActiveCell.Borders(xlBottom).ColorIndex = 18 128 128 128  
    2. Click the Microsoft Office Button.
    3. Click Word Options, Excel Options, or PowerPoint Options. ActiveCell.Font.ColorIndex = 17
    4. In the categories pane, click Popular. ActiveCell.Font.Color = RGB(255, 0, 0)
    5. Select Show Developer tab in the Ribbon. Selection.Interior.ColorIndex = xlNone  'xlColorIndexAutomatic or xlColorIndexNone
    6. Click OK to close the Options dialog box. Selection.Interior.ColorIndex = 5
    Selection.Interior.Color = RGB(200, 250, 200)
    Selection.Interior.Color = &Hc8efac8   'h=Hex,  o=Octal  anyone still use octal
    Color Schemes Table of 56 colors >> http://dmcritchie.mvps.org/excel/colors.htm ActiveCell.Font.Background = {xlAutomatic | xlOpaque | x1Transparent}
   
      Page Layout   Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
    Colors (left side)  >  Office 2007-1010 ActiveWindow.GridlineColor = RGB(255,0,0)
   
    UTF-8 (setup Excell to create web sheets (.htm) with the charset=utf-8) Members of Excel Constants details:
    File > Save As > Web page (*.htm) > . selection sheet > Tools ! >  Web Options … >  Const xlColorIndexNone = -4142 (&HFFFFEFD2)
      Encoding   >   Unicode (UTF-8)  >   check ->  Always save pages in the default encoding Const xlColorIndexAutomatic = -4105 (&HFFFFEFF7)
    OK Const xlAutomatic = -4105 (&HFFFFEFF7)
    Password Protect Const xlBackgroundOpaque = 3
      File > Info >  "Protect Workbook" > "Encrypt with Password" Const xlBackgroundTransparent = 2
    Const xlOpaque = 3
    Wrap text automatically Const xlTransparent = 2
    In a worksheet, select the cells that you want to format.
    On the Home tab, in the Alignment group, click Wrap Text . ...
    Data in the cell wraps to fit the column width. Active X controls not working       >>>>> http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled
   
    Calculate elapsed time (subtract time)
    1. Do the following: ... How To Find and List All Links (External References) In Excel? https://www.extendoffice.com/documents/excel/953-excel-list-all-links.html
    2. In cell A3, type =A2-A1.
    3. On the Home tab, in the Cells group, click Format, and then click Format Cells. Because external links contains bracket [ sign, we can find out the external links if we can get all bracket signs in the whole workbook.
    4. In the Format Cells dialog box, click the Number tab. Step1: Click Home > Find & Select > Find to open the Find and Replace dialog box. You can also open the Find and Replace dialog box with pressing Ctrl + F keys.
    5. Under Category, click Custom. Step2: In the Find What: box, enter the left part of bracket sign "[".
    6. In the Type box, type [h]:mm:ss. ... Step3: Click Options, in the Within drop down list, choose Workbook. And then click Find All button. 
    7. Click OK. Then it lists all external references in the Find and Replace dialog box immediately.
   
    Worksheet tabs and scroll bars disappeared.
    Try this:   View  
    Converting Decimal Degrees to Degrees/Minutes/Seconds
    Arrange All  >  check Windows of Active workbook. The following Microsoft Visual Basic for Applications custom function accepts an angle formatted as a decimal value and converts it to a text value displayed in degrees, minutes, and seconds. 
    Function Convert_Degree(Decimal_Deg) As Variant
    Misc Stuff     With Application
            'Set degree to Integer of Argument Passed
    Do not use "Sort" as a macro name !          Degrees = Int(Decimal_Deg)
     "Sort" is a reserved keyword  -- >  it will give you problems.         'Set minutes to 60 times the number to the right
            'of the decimal for the variable Decimal_Deg
            Minutes = (Decimal_Deg - Degrees) * 60
    Insert > Shapes > Scribble  ( select and right-click to "Format Shape" )         'Set seconds to 60 times the number to the right of the
   
        'decimal for the variable Minute
            Seconds = Format(((Minutes - Int(Minutes)) * 60), "0")
            'Returns the Result of degree conversion
           '(for example, 10.46 = 10~ 27  ' 36")
            Convert_Degree = " " & Degrees & "° " & Int(Minutes) & "' " _
                & Seconds + Chr(34)
        End With
    End Function
   
   
    To use this function, create a conversion formula, as in the following example: 
   
    1. Start Excel and press ALT+F11 to start the Visual Basic editor.
    2. On the Insert menu, click Module.
    3. Enter the sample code for the Convert_Degree custom function described above into the module sheet.
    4. Press ALT+F11 to return to excel.
    5. In cell A1 type 10.46.
    6. In cell A2 type the following formula: 
    #NAME?
   
    The formula returns 10°27'36" 
   
    Converting Degrees/Minutes/Seconds to Decimal Degrees
    The following Microsoft Visual Basic for Applications custom function accepts a text string of degrees, minutes and seconds formatted in the exact same format that the Convert_Degree function returns (for example, 10° 27' 36") and converts it to an angle formatted as a decimal value. This is exactly the reverse of the Convert_Degree custom function.
   
    WARNING: This custom function fails if the Degree_Deg argument is not in the following format :      <degrees>° <minutes>' <seconds>" 
    even if the seconds value is 0. 
   
   
    Function Convert_Decimal(Degree_Deg As String) As Double
       ' Declare the variables to be double precision floating-point.
       Dim degrees As Double
       Dim minutes As Double
       Dim seconds As Double
       ' Set degree to value before "°" of Argument Passed.
       degrees = Val(Left(Degree_Deg, InStr(1, Degree_Deg, "°") - 1))
       ' Set minutes to the value between the "°" and the "'"
       ' of the text string for the variable Degree_Deg divided by
       ' 60. The Val function converts the text string to a number.
       minutes = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "°") + 2, _
                 InStr(1, Degree_Deg, "'") - InStr(1, Degree_Deg, _
                 "°") - 2)) / 60
        ' Set seconds to the number to the right of "'" that is
        ' converted to a value and then divided by 3600.
        seconds = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "'") + _
                2, Len(Degree_Deg) - InStr(1, Degree_Deg, "'") - 2)) _
                / 3600
       Convert_Decimal = degrees + minutes + seconds
    End Function
   
    To use this function, create a conversion formula, as in the following example: 
   
    1. Start Excel and press ALT+F11 to start the Visual Basic Editor.
    2. On the Insert menu, click Module.
    3. Enter the sample code for the Convert_Decimal custom function described above into the module sheet.
    4. Press ALT+F11 to return to excel.
    5. In cell A1 type the following formula: 
    #NAME?
    NOTE: You are required to type three quotation marks (""") at the end of the argument of this formula to balance the quotation mark for the seconds and the quotation mark for the text string. A cell reference will not require a quotation mark. 
   
    6. The formula returns 10.46