sethenoka

#!/usr/bin/env bash
# Ref: ~/.macos — https://mths.be/macos

# Close any open System Preferences panes, to prevent them from overriding
# settings we’re about to change
osascript -e 'tell application "System Preferences" to quit'

# Ask for the administrator password upfront
sudo -v

sethenoka

Sub Pretty_Headers()
' A simple macro to quickly make the header row of an excel sheet prettier
' Designed to:
'       1. Colour all header cells
'       2. Colour all header cell text
'       3. Bold all header cell text
'       4. Apply autofilter to the header row
'       5. Freeze the top row of the sheet
'
' The macro will apply to the active sheet

sethenoka

#!/bin/bash
# This file is designed to spin up a Wireguard VPN quickly and easily, 
# including configuring Pi-Hole as a recursive local DNS server using
# Unbound to block ads a the DNS level
#
# Make sure to change the public/private keys before running the script
# Also change the IPs, IP ranges, and listening port if desired

# add wireguard repo
sudo add-apt-repository ppa:wireguard/wireguard -y

sethenoka

#!/bin/bash
# This file is designed to spin up a Wireguard VPN quickly and easily, 
# including configuring a recursive local DNS server using Unbound
#
# Make sure to change the public/private keys before running the script
# Also change the IPs, IP ranges, and listening port if desired
# iptables-persistent currently requires user input

# add wireguard repo
sudo add-apt-repository ppa:wireguard/wireguard -y