Excel loads and addins install.
Assuming there is a menu for options under addin
"Test", can I create a menu item that will allow a user
to display range("A1:G60") of sheet1 in that addin?

This sheet would hold code (including ActiveX
controls) that then must then be operable.

ie user selects (say) page1 from the menu, and the
said range is displayed. Is this possible, or best to
convert the range to a userform?

Regards.