How to disable excel menu,options in excel 2007?
I'm
doin college project with excel 2007. i'm
using excel sheet as frontend. i want when the excel sheet will open user won't be able to see any excel menu such as "home", "insert", "page layout" etc. i want to know the code which i can write in vba widnow.
main goal is user won't be able to see or bring any excel option or menu, he/she's
interect only with sheet.
i heard there is
object called comman
dbars, but it works with old excel, not excel 2007, i heard if u want to change u have to use xml. dont sure. any idea , qucik and easy way????
Answer
The link in the sources list (below) shows how to modify the ribbon in office 2007 programs. it's
a 3 part series, and the link takes you to part 1.
a bit over halfway down the page, it describes how to hide the ribbon using the startfromscratch attribute. look for the section titled "ribbon customization scenarios for other applications."
tim
http://www.tvmcalcs.com/blog/
Related Products
Warning: DOMDocument::loadXML() [
domdocument.loadxml]: Extra content at the end of the document in Entity, line: 2 in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/domxml-php4-to-php5.php on line
61
Fatal error: Call to a member function document_element() on a non-object in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/amazon.php on line
50