× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.







Thanks Bill.  I suspect that I got myself into design mode by adding the
new button.  At that point I was able to delete the previous buttons.  I'm
no Excel expert.  I've done a fair amount of work in Access with buttons
and macros but nothing obvious jumped out at me in Excel.  Everything I
know in Excel I've learned because people ask me questions on how to fix
their problems.  Today I learned something new.  Thanks.


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx




                                                                                
                              
                      Bill                                                      
                              
                      <billzbubb@hotpop        To:       PC Technical 
Discussion for iSeries Users            
                      .com>                     <pctech@xxxxxxxxxxxx>           
                              
                      Sent by:                 cc:                              
                              
                      pctech-bounces@mi        Subject:  Re: [PCTECH] Getting 
rid of Excel macro buttons      
                      drange.com                                                
                              
                                                                                
                              
                                                                                
                              
                      06/16/2005 06:02                                          
                              
                      PM                                                        
                              
                      Please respond to                                         
                              
                      PC Technical                                              
                              
                      Discussion for                                            
                              
                      iSeries Users                                             
                              
                                                                                
                              




daparnin@xxxxxxxxxxxxxx wrote:

>One of our users has an Excel spreadsheet that she inherited from someone
>else who no longer works here.  It has "sort" and "roll" buttons that are
>supposed to run macros but they don't work.  The macros are fine but the
>buttons don't work and she would like to get rid of them.  An alternative
>might be to fix them so that they run the macros.  These buttons are not
on
>the tool bar but down in the cells.
>
>Can anybody suggest where I should look?  Thanks.
>
>
>
Dave,

I know you found a workaround for this, but the "correct" method is to
display the Controls Toolbar and then select the Design Mode button to
enter design mode.

Bill
--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
 at http://archive.midrange.com/pctech.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.