Hi,

That button is from the Forms toolbar rather than the Control toolbox
toolbar. It does not stop you from going into Design mode it's just that
Design mode has no effect on this type of button. It will also not stop
the user from going to the vb editor. Just try ATL+F11

Cheers
Andy

rajendran wrote:
Thanks Bop.I know to protect the code. but my question is

How to make the workbook button like the one available in this
http://www.andypope.info/vba/progressmeters.zip. When we open this
workbook when place our cursor over the button it has been changed to
Hand Sympol.And also if i select the design mode and click the button ,
it wont allow me to go the design mode(ie scripting). it is executing
the code. i want to how to do this.

Thanks
Raj



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info