Smart button won't go away


    Sponsored Links


  • 1. Charting Statistical Distributions in Excel 2008
    I've been able to chart in Excel 2008 for a Normal Curve using the NORMDIST function and other calculated cells. It is a thing of beauty. I'd also like to draw continuous data charts with negative and positive skews, F Distributions, t Distributions, and Chi-Square Distribution. Does anyone know how I might do this things. I've search online and haven't not found what I need. Thanks, Ed
  • 2. Formatting Cleaner?
    Version: 2004 Operating System: Mac OS X 10.5 (Leopard) I know there's a formatting cleaner for PC's, but I can't find it for macs. Does it exist?
  • 3. Lost another hour of work
    Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Old habits die hard. I keep forgetting that I can't right-click in Excel or Word 2008 on Mac, or THE WHOLE APPLICATION CRASHES. I've been reporting this for, oh, I don't know, 6 months? I've emailed the error stack a bunch of times. Is this something that you are actually going to fix, or is the answer "it's something in your user account" the only one available? Because even if something is my user account, shouldn't the Office suite, which I've been buying the professional version of religiously for about 100 YEARS be able to handle it and not crash and lose my work?
  • 4. Database Error in Excel
    Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a database of names (lets say 50). When I want to send out a form letter in Word and use a portion of these names (lets say 10) by deleting those I don't want from the original document or cutting and pasting those I do want into a new document. I then do a print merge (form letter) in Word and it will print all 50 documents when I only wanted 10. When I look at my data record (excel spreadsheet) it shows an asterisk in row 11 (instead of the number 11) and a highlighted border around all entries on that page. What is going on here? I only want the 10 entries not 50.
  • 5. Standard Toolbar has Disappeared in Excel
    Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi, I know this question has been posted before however I can't seem to get any of the previous answers to work for me. I'm a relatively new mac user and am experiencing a problem with my Excel. Every time I open a new sheet the standard toolbar is "missing" when i go to the tool bar options it is however checked, i have to uncheck it and then re check it to get it to appear again . In the customize toolbar menu the standard tool bar is ticked in dock but is shaded out and I cannot change this. I have tried resetting it but that does now work either. I was using Excel for at least 6 months before this problem occurred. Would be very grateful for any help ! Thanks !!

Smart button won't go away

Postby Slipface » Wed, 14 Nov 2007 10:17:01 GMT

As I'm pasting some copied text into various cells in a spreadsheet
(basic cmd-V), the Smart Button won't go away and it's obscuring text
in the cells that it's sitting atop of.  I can't get it to go
away--pressing escape, selecting one of the options in the smart button
menu, scrolling off screen then back...

Any thoughts?  I'm using Excel 11.3.5 (current as far as I know) and OS


Re: Smart button won't go away

Postby jpdphd » Wed, 14 Nov 2007 11:57:30 GMT

Oh my, that's a persistent little {*filter*}! What I found was that if you
hit escape while the marching ants (marquee) are still active (you see
them around the copied cells immediately after 'copy'), poof! the dumb
smart button disappears. But woe to you if you do something (anything)
that stops the ants. Well, if you go to a blank cell and just type
something, SB goes away. Better yet, do a save (never a bad idea).
btw, after the marching ants retreat, pasting will paste only the
contents of the source cell - no formats, no formulas. So you could
regard a persisting SB as a warning that you might be missing


Re: Smart button won't go away

Postby CyberTaz » Wed, 14 Nov 2007 20:39:14 GMT

You also have the option of going to Excel> Preferences> Edit & clearing the
check for Show Paste Options Buttons... FWIW, I personally prefer to
Right-Click & use Paste Special if I want something other than a straight
paste, anyway.

HTH |:>) 
Bob Jones 
[MVP] Office:Mac

On 11/12/07 8:17 PM, in article 121120071717013396% XXXX@XXXXX.COM ,

Re: Smart button won't go away

Postby Slipface » Thu, 15 Nov 2007 14:55:04 GMT

In article <C35EF712.2D350% XXXX@XXXXX.COM >, {*filter*}Taz

Thanks, folks.  I did see the preference option...I do make modest use
of the smart buttons (when dragging the corner of a cell to copy it,
and change the copied cells to a series, for example), but could
probably work around it just as well.  Maybe I'll play around with the
settings and see which way bugs me least :)


Re: Smart button won't go away

Postby Slipface » Thu, 15 Nov 2007 14:57:35 GMT

In article < XXXX@XXXXX.COM >,

Now *that* is interesting, and could very well explain another source
of occasional frustration.  Sometimes I wonder why pasting includes
formats and sometimes it doesn't...

Although I am much more frustrated with pasting and formatting in Word,
where it seems to have a mind of its own sometimes ;-)


Similar Threads:

1.Excel won't go away

I have tried several variations of the following function, but can't seem to 
get excel to quit at the end if I have all the excel formating in place.  It 
seems to lose it's connection to excel.  Someone got any ideas?

Function convert_files() As Boolean
On Error Resume Next
DoCmd.SetWarnings False
Dim xl As Object
Set xl = CreateObject("Excel.application")
xl.Application.Visible = False
xl.Application.UserControl = False
xl.DisplayAlerts = False
xl.Interactive = False
xl.ScreenUpdating = False
Dim xlbook As Object
Dim xlsheet As Object
Dim fs, f, f1, fc, s, wk, firsttime, tn, fn, qt, ch
Dim mindate, maxdata As Date
Let firsttime = True
Let qt = "Query_template"
Set fs = CreateObject("Scripting.FileSystemObject")
'   clear archive directory
fs.deletefile "C:\KH\Archived\*.csv", True
'   setup directory search for csv files
Set f = fs.GetFolder("C:\KH")
Set fc = f.Files
For Each f1 In fc
    If Right(f1.Name, 3) = "csv" Then
        '   create xls file name from csv file namefrom template to create 
xls file
        Let tn = Mid(f1.Name, 4, 3) & Mid(f1.Name, 8, 4)
        Let wk = "C:\KH\LD_" & tn & Format(f1.DateCreated, "yyyymmdd") & 
        '   create a work table from the table template 1 time
        If firsttime = True Then
            DoCmd.CopyObject , "work_table", acTable, "table_template"
            Let firsttime = False
        End If
        '   load the work table from the csv file
        Let fn = "C:\KH\" & f1.Name
        DoCmd.TransferText acImportDelim, "KH Import Specification", 
"work_table", fn, True
        '   export the work table to the xls file using the copy of the 
query template
        DoCmd.CopyObject , tn, acQuery, qt
        DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, tn, wk, 
        DoCmd.DeleteObject acQuery, tn
        '   get the Min and Max check dates on the file
        Let mindate = DMin("[check date]", "work_table")
        Let maxdate = DMax("[check date]", "work_table")
'        MsgBox maxdate
        '   open the xls file
        Set xlbook = xl.Workbooks.Open(wk)
        Set xlsheet = xl.ActiveSheet
'   for debugging
'        x = xlsheet.Name
'        MsgBox x
'        x = xlsheet.Name
'        MsgBox x
        ' freeze row 1 for display
        ActiveWindow.FreezePanes = True
        '   bold row 1
        With xlsheet
            For Each cell In xlsheet.Range("A1", "O1")
                cell.Font.Bold = True
        End With
        '   autosize row 1
        With xlsheet
            .Columns("A:N").Font.Name = "Arial"
            .Columns("A:N").Font.Size = 9
        End With
        '   set headers and footers
        With xlsheet.PageSetup
            .PrintTitleRows = xlsheet.Rows(1).Address
            .PrintTitleColumns = xlsheet.Columns("A:O").Address
            .Orientation = xlLandscape
            .FitToPagesTall = False
            .FitToPagesWide = 1
'            .CenterHeader = "Labor Distribution " & Chr(10) & "for" & 
Chr(10) & "&A"
            .LeftHeader = "&B" & "Check Dates " & mindate & " to " & maxdate 
& "&B"
            .CenterHeader = "&B" & "Labor Distribution for " & "&A" & "&B"
            .CenterFooter = "&F" & " " & "&D"
            .RightFooter = "&R Page &P of &N"
            .LeftMargin = xl.InchesToPoints(0)
            .RightMargin = xl.InchesToPoints(0)
            .TopMargin = xl.InchesToPoints(0.5)
            .BottomMargin = xl.InchesToPoints(0.5)
            .HeaderMargin = xl.InchesToPoints(0.25)
            .FooterMargin = xl.InchesToPoints(0.25)
        End With
        '   save and close workbook
        Set xlsheet = Nothing
        Set xlbook = Nothing
        Let fm = "C:\KH\archived\" & f1.Name
'        s = s & fn
'        s = s & vbCrLf
        fs.movefile fn, fm
        DoCmd.OpenQuery "erase_work_table"
        End If
'    MsgBox s
    DoCmd.DeleteObject acTable, "work_table"
    '   cleanup
    Set xl = Nothing
    Set xl = GetObject(, "Excel.Application")
    If Err.Number <> 0 Then
        MsgBox "Excel not found " & Err.Number & " " & Err.Description
        MsgBox "Excel found " & Err.Number & " " & Err.Description
        Set xl = Nothing
    End If
    Set f = Nothing
    Set fc = Nothing
    Set fs = Nothing

End Function

2.Excel.EXE won't GO away

I've been using excel within VB.NET applications and I can't get it to close down and remove itself from memory.

I'm using Visual Studio 2003 ver 7.1.3088, Framework 1.1, MS Office 2003 with MS VS Tools for MS Office System 69586-3

After closing all workbooks etc and setting them to nothing, I run the following code to get rid of the Excel Application object

	If Not (xlApp Is Nothing) Then
		xlApp = Nothing
	End If

This does set the application object to nothing in the locals panel but the Excel.EXE process is still running in the Task Manager.

Thanks for your help.

3.XL 2000 'calculate' won't go away

Ready     Calculate
won't go away

The spreadsheet is large and has many complex formulas, but
no custom functions.  I've tried shift-F9, save & re-open,
and other workstations.  All updates

any help appreciated.

4.Help! Draft Watermark Won't Go Away


I've got a 2003 XP Excel file with a Draft watermark on it - it is not in 
header, it is not background, it does not appear to be word art - but if it 
is word art how would I select it to delete it?

I cannot get rid of the mark and I'm going crazy!  I'm going to have to copy 
and paste and redo 12 sheets.


5.Macro won't go away!

I've deleted a macro from a workbook that didn't work correctly.  It's the 
only macro in the workbook.  And I know it's gone because the macro list is 
now empty. But whenever I open the file, I'm still confronted with the 
message box that asks me whether I want to disable or enable the macros. 
Can anyone tell me how to make this message go away?

thanks much

6. #value won't go away

7. Macro that won't go away!

8. Compile Module Error (TBRun9) just won't go away

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 80 guest