Extract Address from an Excel Hyperlink

Function HLink(rng As Range) As String
'extract URL from hyperlink
'posted by Rick Rothstein
  If rng(1).Hyperlinks.Count Then HLink = rng.Hyperlinks(1).Address
End Function


Reference:
http://blog.contextures.com/archives/2010/12/13/get-the-url-from-an-excel-hyperlink/

AppOffline.htm

Site Under Construction
App Offline

AppOffline.htm
Place this file in the root of the application.

Reference:
http://weblogs.asp.net/scottgu/archive/2006/04/09/442332.aspx

Simulate iPhone or iPad with Safari

Safari > Gear icon > Preferences > Advanced > Check 'Show Develop menu in menu bar' > Alt > Develop > User Agent > [Safari iOS 4.3.3 - iPhone | Safari iOS 4.3.3 - iPhone]

BackConnectionHostNames Registry Location

BackConnectionHostNames Registry Location:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0

(Used to specify the host names that are mapped to the loopback address and can connect to Web sites on your computer)

Resource:
https://support.microsoft.com/kb/896861

Rename Web Application and Alternate Access Mapping Collection

$wa = Get-SPWebApplication | where {$_.Name -match "localhost - 80"}
$wa.Name = "My Web App"
$wa.Update()
$aamc = $wa.AlternateUrls
$aamc.Name = "My Web App"
$aamc.Update()

Resources:
http://www.topsharepoint.com/rename-web-application-in-sharepoint-2010

httpModule

Right-click project > Add > New Item... > Visual C# > Web > ASP.NET Module > Change 'MyModule1.cs' to your own name
 
Reference:
http://go.microsoft.com/?linkid=8101007
http://blog.mastykarz.nl/accessible-404-pagenotfound-in-microsoft-office-sharepoint-server-2007/

Edit Permissions

http://sample.local/_layouts/editprms.aspx?sel=3