Saving CommandBar with Workbook

P

pjd

I have created and attached a Command Bar to an Excel 2000 workbook.
want to distribute the workbook, but when I try to open it on anothe
machine, also using Excel 2000, I get a "Runtine error 5, Invali
procedure or argument" when I debug the script I get the following lin
highlighted "Application.CommandBars("SalesPlannerPlus").Visible
True"

Can anybody help?

Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
Run time error 2
reset hidden commandbars using workbook_beforeclose() 3
Workbook_open not executing 3
How do I delete an attached commandbar in an Excel 2007 Workbook? 1
CommandBar docking with VBA 2
Why do charts disappear? 3
Toolbar built for 2003 not loading in 2007 2

Top