Floating Toolbar

  • Thread starter Thread starter Roger Bedford
  • Start date Start date
R

Roger Bedford

I have an Excel 5 file where the macros automatically turn a floating toolbar
off if another sheet in that file is selected or if the file is closed.
However it does not turn off the floating toolbar if I change to another open
file. How do I solve this and would there be a change to the solution if I
were using Excel 2002? Any suggestions would be much appreciated.

Roger
 
Andy, thanks for your reply. I have a button that is active on one sheet of
an Excel file which is what I like as the macro turns off the button on the
other sheets. The problem is that it doesn't turn it off if another workbook
is used. As my programming capabilities are very limited is there a section
off of one of your files that deals with just that issue or does anyone else
have a solution?
Thanks,
Roger
 
Back
Top