Excel 2007 : Spin Button Macro

HI .. Trying to use Code prepared By "Palmetto" for a very dymamic range based spin buttom , It works perfectly in his downloadable sample worksheet, and is exacly what I need, but I just can't reproduce it. Here's the forum link "http://www.excelforum.com/excel-programming/720986-spin-button-macro.html", I've tried adding a "spinbutton 1" on the spreadsheet and placing the code in the "Tab"> "View code", as described, but it never works, Any help would be appreciated. P.S. I'm new to this so basics are appreciated.

Good afternoon traimaran

...and welcome to the forum!!

First, I assume you have your Developer tab showing in Excel?
Second, you need to design your gadget from the Insert menu under the development tab.
You need to be using the ActioveX controls - not the form controls.
However, when you start drawing them, you enter "Design Mode" - see the big button change next to insert. Before you can start using your button you need to turn Design mode off again - it's a toggle button. Click it again.

Thewn you can stick your code in the sheets module.

Look at my instructions in the same post.

HTH

DominicB

dominicb; Thank you kindly. Turning off the design mode fixed it, I have a dissapearing ribbon and did not understand design mode button was still on.