Custom ToolBars

  • Thread starter Thread starter Julian
  • Start date Start date
J

Julian

Have created two custom toolbars in Excel with macros
attached to the buttons. The macros, written in VB, are
contained in personal.xls

When I try to run these buttons, I frquently get the
message "Document with the name Personal.xls is already
open"
 
check you location of personel book.. you must be having two books i
different folders.

better way is to save your workbook as addins and then browse an
select the addin ..

other way is to give reference to your workbook from vba.. so th
workbook where you want to use your macros..this prevents every time
workbook to be open
 
Back
Top