Re: Getting rid of Excel macro buttons

[daparnin@xxxxxxxxxxxxxx]

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.