Solved

Removing button from Excel spreadsheet - Excel 2007

Posted on 2011-03-03
2
846 Views
Last Modified: 2012-05-11
I have a spreadsheet which has a button control.  I hae put an Exit Sub in the module so it will not execute.  I would like to remove the button.  I can't seem to bring up properties or any options when I hover over it.  I can I delete the button.  The worksheet is in "unprotect" mode.
0
Comment
Question by:morinia
  • 2
2 Comments
 
LVL 13

Accepted Solution

by:
Brum07 earned 250 total points
ID: 35027300
To delete the button, show the Control Toolbox toolbar, select Design Mode, select the button and cut/delete the button.

Regards
0
 
LVL 13

Expert Comment

by:Brum07
ID: 35027336
Sorry for 2007:

Go to the Developer tab (If you not see this go to Office Button>Excel Options....Popular), Click on the Design mode button thneDelete the button, Click again on the Design Mode button

Regards
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now