Create an Excel Shortcut Menu That Writes Selections to a Text File
- Posted: Aug 22, 2008 at 5:25PM
- 14,507 views
- 2 comments
Loading user information from Channel 9
Something went wrong getting user information from Channel 9
Loading user information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
Right click “Save as…”
It doesn't take much code to add a command to a shortcut menu in Excel, but the menu objects have strange names so it's not intuitive, to me at least. The trickiest part is just sorting out how it's supposed to work, because it seems like it should be different from adding buttons to toolbars, but it really looks like that's what you're doing.
The code is all posted in
this post on the VSTO team blog.
Thanks to McLean Schofield, programmer/writer and 3-star forum answer person, for this code example!