Floating "Nav." window

I want to create a floating window in excel that can contain a series of macro buttons (12 total)

I'd like to see if this window can be opened with a hyperlink or a single macro button on a spread sheet.

I'm lost as far as this goes.

Can anyone help?

http://www.contextures.com/xlUserForm01.html is a place to start learning about userforms.

Are you using Excel 2007?

Your code isn't in the click event of the button so the button won't work. In the VB Edito doubleclick on the buttons, this will open the button's click event, that's where the code should be,

Private Sub PowerSupply_Click()

'
' PowerSupply Macro
' Insert Power Supply
'

'Go to Sheet Named "Factors"
    ActiveWorkbook.Sheets("Factors").Select
'Select Cell "D22"
    ActiveSheet.Range("D22").Select
'Set Value of "D22" to "P"
    ActiveCell.FormulaR1C1 = "P"
'Select Range Labeled "PowerAtten"
    Range("PowerAtten").Select
'Copy Range
    Selection.Copy
'Go to Sheet Named "Sheet1"
    ActiveWorkbook.Sheets("Sheet1").Select
'Insert Copied Range into Select Cell
'Move Rows Down
    Selection.Insert Shift:=xlDown
'Move Active Cell Down 1 Row and to the right 0 columns
    ActiveCell.Offset(1, 0).Select
End Sub

You don't actually need to select the sheet or range

Your Office Version is listed as Excel 2007, bu you attached a 2003 workbook.

I can't tell from your code where you are copying to.

Look at the FollowHyperlink method in the VBA help files.

As I said previously you don't need to select sheets & ranges, you can copy cells, etc without doing so

You can use Application.GoTo, bu as i keep saying for faster, more efficient code you do not need to go to the ranges.