Create new button via Applescript in Excel 2004

E

Ed Zachary

I've tried the Excel2004AppleScriptRef.pdf sample code on page 30, but
get an error "can't make class command bar button". How does one do
that - create a new button? Here's the code:

tell application "Microsoft Excel"

set newItem to make new command bar button at command bar "Tools"
set begin group of newItem to true
set caption of newItem to "Make Report"

end tell
 

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

Top