Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2013, 05:52 PM
hannu hannu is offline How to remove Spin button Windows 7 How to remove Spin button Office 2007
Advanced Beginner
How to remove Spin button
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default How to remove Spin button

I am experimenting and learning to use Spin buttons as Form controls. I have made a spin button and make it count "clicks", so far ok. But if I want to edit the form and delete or remove the button then what? All instructions seems to tell how to make one but none tell how to delete or remove it? any ideas?


there must be a simple way to do it, i just can't figure it out.
Reply With Quote
  #2  
Old 11-13-2013, 05:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to remove Spin button Windows 7 64bit How to remove Spin button Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Not quite sure but when in Edit mode right click on it and delete
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-13-2013, 06:10 PM
hannu hannu is offline How to remove Spin button Windows 7 How to remove Spin button Office 2007
Advanced Beginner
How to remove Spin button
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default

Thanks Pecoflyer, I did that but it seemed such a clumsy way to delete if there are many many Spins. looks more like Access than Excel design.
Reply With Quote
  #4  
Old 11-14-2013, 01:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to remove Spin button Windows 7 64bit How to remove Spin button Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

In that case, VBA would help. Unfortunately it's not my cup of tea. I usually Google around and adapt the found code to my needs
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove Spin button Export to .txt button? skrallemand Word VBA 1 10-11-2013 12:38 AM
How to remove Spin button How to run two button macros with one button? Geza59 Excel Programming 1 02-14-2013 12:11 AM
How to remove Spin button How to remove "Table of Figures" as we do to remove the "Table of Contents"? Jamal NUMAN Word 1 07-08-2011 05:40 PM
How to remove Spin button Command Button cksm4 Word VBA 7 02-27-2011 08:47 PM
Macro Button B2W Excel 2 06-18-2010 09:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft