How to Remove a Button on sheet

Gidday,
I do not like to use buttons on worksheets because I was 
fooling around and suddenly I have a button on the sheet 
that cannot be right clicked or deleted.
Should I change something in the properties window before 
I close it?
I am using Excel 2000 but also found this problem with 
Excel 97.
Regards

Mark

PS This is why I only use Userforms or toolbar buttons to 
initiate macros.


0
5/21/2004 5:17:35 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
422 Views

Similar Articles

[PageSpeed] 31

You need to get into design mode to edit controls in worksheets. If yo
bring up the "control toolbox" toolbar and click the design mod
button. This should then enable you to delect the button

Dunca

--
Message posted from http://www.ExcelForum.com

0
5/21/2004 9:55:39 AM
Reply:

Similar Artilces:

How do i create a button to Compact & Repair?
Hello there,Is there anyone who can help me out with this question.How do i create a button to Compact & Repair?Any help with this matter would be greatly appreciated.TIATORQUEMar. 23, 2007--------------= Posted using GrabIt =----------------------= Binary Usenet downloading made easy =----------= Get GrabIt for free from http://www.shemes.com/ =- On Fri, 23 Mar 2007 22:55:58 -0500, "TORQUE" <NoEm@il.Please> wrote:>Is there anyone who can help me out with this question.>How do i create a button to Compact & Repair?I rather doubt that you can.Compaction works ...

repost; Automatically updating formulae in multiple sheets
I list sales of 20+ products each week for the year A2-A23 are the products and B-BA are the colums for each week I have multiple sheets that have the same sales results in the same format foreach previous year 2004;2003;2002;2001;2000 Each week I want to compare total sales in the year to date i.e weeks 1-20 with weeks 1-20 in each previous year. so next week it will be 1-21. I have on each sheet a cumulative total for each of the 20 products in the year to date i.e Cell A25=SUMB2:BA2 and Cell A26=SUMB3:BA3 and so on for each product. This means each week I have to alter the formula in C...

Removing, Hiding Public and System Defined Views in 4.0
Does anyone know how to either remove or hide, Public and System Defined Views in 4.0? For example nobody wants to see "Accounts: No Campaign Activities in Last 3 Months" or "Accounts: Responded to Campaigns in Last 6 Months" Also, I have yet been able to see how you share views in 4.0 Thank you for the help! ...

windows server 2008 wbadmin not remove old backup
I have a win 2008 R2 To backup I use 1) an iternal HDD ( with schedule backup) that works fine and 2) a dell rd1000 external cardridge ( external removable device) for disaster recovery, with two cartridge, with a wbadmin scipt On rd1000 since 10 days the old backup are not removed so the device become full after few backup. I've checked and the is no whadow copies on it. I remember that for more than 1 month it seems to worked fine, old backups was removed and never get full. No errors on event viewer. Any suggestion? Thank you Alessandro ...

I have to compare two sheets for changes
Hi I have to try and compare 2 sheets and highlight the cahnges, what is the best way of doing this in VBA, I was going to try and do it cell by cell but I was wondering if there was a quicker way?. Any help would be much appreciated. Regards Charles Maybe you can make use of conditional formatting, e.g. if you want to compare newsheet to oldsheet which is an earlier version of newsheet, then apply CF on newsheet! Select A1 then select used range on newsheet and create CF with formula =A1<>oldsheet!A1 Choose a pattern and press OK! -- Regards! Stefi „vqthomf” ...

Open workbook to given sheet
Can anyone tell me how to open an Excel work book on the internet to a given page in the workbook Example: Test.xls sheet(start) I can open a workbook to a given page from another MS application I would like the html code for this Thanks to all Dale ...

Check if a sheet exists
I have a workbook with a number of sheets (n) that changes. Each sheet in the workbook is named; " Sheetn " where n is th sheet number (e.g. Sheet1, Sheet2, Sheet3 etc.) I need to know the VBA to check whether a sheet exists; something alon the line of this sheetloop = 1 do domacroonsheet(sheetloop) <--- My other macro that does stuff sheetloop = sheetloop + 1 loop until exist(sheets("Sheet" & sheetloop))=false Can someone correct this for me please; I'm desperate to get thi working! Many thanks in advance! :confused -- Message posted from http...

How does page navigation buttons help me view a publication?
How does page navigation buttons in Publisher help me view a publication? Rebecca <Rebecca@discussions.microsoft.com> was very recently heard to utter: > How does page navigation buttons in Publisher help me view a > publication? They don't, unless you export to a website. If you export to a website, you don't get Publisher's page buttons at the bottom of the screen, so you need a page navigation bar. -- Ed Bennett - MVP Microsoft Publisher ...

Upgraded to 2003 Now the 'Type to Fnd Contact' button is broken
Hi, I have upgraded from Outlook XP to Outlook 2003. All the contacts are visible, but when I use the 'Type to find contact' button Outlook cannot find any matching contacts (although they are definitely there). Anyone know what is wrong or how to fix it? Thanks Paul Right click on your contacts folder, go to properties, outlook address book, and tick the box. Paul wrote: > Hi, > > I have upgraded from Outlook XP to Outlook 2003. All the contacts are > visible, but when I use the 'Type to find contact' button Outlook > cannot find any matching contacts (a...

Remove Monitoring SBS 2008
How do I completely remove monitoring in SBS 2008? Why do you want to break your SBS box? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008 Support - www.SBITS.Biz Question or Second Opinion - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com "Bobby Janow" <bjanow@msn.com> wrote in message news:2AF88A26-BFF7-4C17-87AC-D1E62921204C@microsoft.com... > How do I completely remove monitoring in SBS 2008? Bobby Janow wrote: ...

How do I copy a print format from sheet to sheet in excel ?
I would like to copy a printing format to other sheets in a workbook including print areas and print titles. Is this possible does anyone know? Thanks. Hello- Unless I'm missing something, most everything you're asking *is* done automatically since your print specs are for the workbook, not sheet-by-sheet. Headers/Footers, Rows to repeat@top, margins, etc. apply to all sheets, and Print Areas need only be set if you want to print a portion of what would normally be output. You might want to consider Named Ranges if you haven't already done so. HTH |:>) "kernat&qu...

Protect a sheet from Printing within a workbook?
I am making an ordering spreadsheet for my customers. On one sheet, there is every style # of THEIRS, with the corresponding style # of MINE (to preface, my customers refuse to make my life easier by ordering with our style #s, so I have to make up 20 of these sheets for various large customers..but thats beside the point). Again, on one sheet, is about 1000 style #s in two columns (their # and my #) The second and third sheets, are the ones that they are going to use to send in orders to me. When they email me an order, my computer is set to automatically print out the xls files attached ...

QAT looses custom button.
Hi, I'm having a strange problem with word 2007 and the QAT. I've created a custom tab page with several buttons on it. If I right click on a certain button, I can add it to the QAT. If I look at the word.qat file is see (among things) this line : <mso:control idQ="x1:SaveChanges" visible="true" imageMso="SaveAndClose"/> If I close and reopen Word, my button is gone from the QAT (but the above line is still in the word.qat file). If I then close Word, the line is removed from the word.qat file (and my button is ,of course, still gone). ...

Add/Remove Programs
Can anyone help with this one. Am working on old XP2600 / XP Home SP3+ based machine, and in Control Panel | Add/Remove programs "Windows Live Essentials" is unresponsive when I click on its' Add/Remove button. The hard disk rattles for a fraction of a second and the "Currently installed Prgrams screen refreshes, then, ...nothing ! I have uninstalled all apps. under the Windows Live Essentials "umbrella" but, am not getting very far. TIA regards, Richard ...

remove file from most recent files listing
How do you remove the listing of a money file from the recent used files list? It is confusing for the person to see the file listed there when it has been deleted intentionally because it is no longer used. In microsoft.public.money, pk wrote: >How do you remove the listing of a money file from the recent used files >list? It is confusing for the person to see the file listed there when it >has been deleted intentionally because it is no longer used. See http://support.microsoft.com/kb/841213/en-us Solved my own problem. It is located in the registry key under HKCU\softwa...

removing mailbox in Outlook
I am the system admin and have the ability to add other users mailboxes to my Outlook. I added one while the user was on vacation and now I am unable to remove it. I dont know if this is an Exchange or an Outlook issue. In outllok under tools, services, properties, advanced, there is an option to add or remove mailboxes (if you have the permission) The one I added is not listed as added . I'm stumped. I also posted this in the outlook group but havent gotten a reply. These are the steps for Outlook 2002. Previous versions of outlook are very similar. -Right click on your exchange icon ...

how to extend data to next sheet automatically during sql query
When returning data from excel query builder, if the data exceed 65536 rows then an error pops up. Can we extend the remaining data to next sheet automatically. Can u plz suggest. As a work around, you might want to create a pivot table that imports external data. That way your not stuck with that same limitation. "Asha" wrote: > When returning data from excel query builder, if the data exceed 65536 rows > then an error pops up. Can we extend the remaining data to next sheet > automatically. > Can u plz suggest. ...

how do I paste a relative formula in multiple sheets?
I have multiple sheets in a workbook. One sheet for each business day of the month. I want to be able to carry over one cell (F66) to the next day's sheet's (F3). THat in itself is easy enough, however the problem comes when I try to copy and paste that formula ( ='Day 2'!F66) to the next day's sheet. The reference to 'Day 2' stays absolute. I need it to be relative. As I paste the formula, I need it to change the 'Day 2' to 'Day 3' and so on. It needs to just pick up the name of the sheet prior to itself. I know there must be a way to ...

microsoft.public.test has been removed because it violated
because it violated Google's terms of service! wot de phuk? I can only guess kiddly fiddlers or some other low-lifes were using it as a cover to exhange illegal info? ...

Can I list my workbook sheets?
I have an excell workbook in which there is a pricelist sheet for ingredients and a (soon to be) large number of recipe sheets. Is it possible for me to devise a list of recipe sheets from which I can choose the recipe I wish to work on? Also, can I have the user use a form for data entry, not the general one on the Data menu? Thank you for your help. Jenny ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** Hi for the second question see: http://j-walk.com/ss/dataform/index.htm -- Regards ...

Looking up data from another sheet
Sorry if this has an easy answer, but I've been wracking my brain trying to figure out how to do this and have thusfar come up empty. I've got a workbook that on the first sheet takes ID number data in from a card reader, formats it, and time-stamps it (it's to keep track of the users of a supply area). On the second sheet (same book), I've got a listing of ID numbers, names, and departments for all the users of this room (there are over 1000). What I'm trying to do is have a cell on the first sheet look up the name associated with an ID number and put that information ...

Remove from Server Outlook 2003
For a POP server account is there a way to SELECTIVELY remove files from a server if the leave on server option is check for that account WITHOUT deleting the message in Outlook? Logon to the webbased interface of your account and remove the files from there. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- <annonymous@discussions.microsoft.com> wrote in message news:o3jpn0tktoia1m3phfc0rvaooppc2hq2j9@4ax.com... > For a POP server account is there a way to...

edit names of multiple sheet tabs at the same time
I have 59 sheets, with the sheet tab name containing the total number of sheets: i.e., "Page 5 of 59". After revisions, I now have 63 sheets. How do I edit all tabs at the same time, such that "Page 5 of 63" appears? That is, I only want to edit the total number of sheets, all else remains unchanged. I searched Help, (with the question: edit names of multiple sheet tabs) it only suggested editing tabs one at a time. Any help would be a big timesaver, and greatly appreciated. Best regards, John Cole One way: Public Sub RenameSheets() Dim wsSheet As Works...

Can you Quick change between two sheets like Alt+Tab?
I know that you can change between two programs in windows with Alt+Tab, but how do you do that between two sheets, or tabs, within a workgroup? Is there a hot-key or shortcut to do this? Hi CTRL+PGUP CTRL+PGDOWN -- Regards Frank Kabel Frankfurt, Germany nwg wrote: > I know that you can change between two programs in windows with > Alt+Tab, but how do you do that between two sheets, or tabs, within a > workgroup? Is there a hot-key or shortcut to do this? it's cntl and page up/page down "nwg" wrote: > I know that you can change between two programs in wind...

No Bound Sheets Found Error Dialog Box-Excel 2000 #2
Hmm, does it matter that other sheets pull from this file? I have two reports that refer to the cells. In other words, this is the big kahuna. The other sheets do not mean alot unless this sheet is up to date. This sheet, that I called MonthlyPDtime, is a sheet that has colunms of employees names. The rows are functional buckets that the time goes into. Each cell has the following: =path,week#yr:employee name!$cell+path,week#yr:employee name!$cell+path,week#yr:employee name! $cell+path,week#yr:employee name! $cell+path,week#yr:employee name!$cell format. Each month has four or...