toolbar macro for esp. worksheet

  • Thread starter Thread starter Mauricio
  • Start date Start date
M

Mauricio

Hello,
I'm trying to coustumase a tool bar to have only the
kind of command buttons that I need and some are actualy
use to open a userform within a template worksheet, and
untile I close that workbook, works find but once I
saveclose it, the template lose all conection to the
macro. now the macro is only conectet to the save
worksheet I close early.
Eny help will be very much apreciated.
Mauricio R.
 
Mauricio

The way that I handle that problem is to create the toolbar in code when the
workbook opens and delete it when the workbook closes. That way, the
buttons will always point to the macros in that workbook. For some
workbooks, I use the Activate and Deactivate events instead of the Open and
BeforeClose events because I may have more than one workbook open that's
based on the same template.

Post back if you need help creating the toolbars in VBA.
 
Back
Top