Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onOpen() {
- var ui = SpreadsheetApp.getUi();
- // Or DocumentApp or FormApp.
- ui.createMenu('Inhoudsopgave')
- .addItem('Uren', 'menuItem1')
- .addSeparator()
- .addItem('Marge','menuItem2')
- .addSeparator()
- .addItem('Omzet','menuItem3')
- .addSeparator()
- .addItem('Bonus','menuItem4')
- .addSeparator()
- .addItem('Pie Charts','menuItem5')
- .addToUi();
- }
- function menuItem1(){
- var strRange = Browser.inputBox("Om naar UREN te gaan vul dan in A2:", Browser.Buttons.OK_CANCEL);
- if(strRange != "cancel")
- {
- try
- {
- SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
- }
- catch(e) {Browser.msgBox(e.message);}
- }
- }
- function menuItem2(){
- var strRange = Browser.inputBox("Om naar MARGE te gaan vul dan in A191:", Browser.Buttons.OK_CANCEL);
- if(strRange != "cancel")
- {
- try
- {
- SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
- }
- catch(e) {Browser.msgBox(e.message);}
- }
- }
- function menuItem3(){
- var strRange = Browser.inputBox("Om naar OMZET te gaan vul dan in A382:", Browser.Buttons.OK_CANCEL);
- if(strRange != "cancel")
- {
- try
- {
- SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
- }
- catch(e) {Browser.msgBox(e.message);}
- }
- }
- function menuItem4(){
- var strRange = Browser.inputBox("Om naar BONUS te gaan vul dan in A579:", Browser.Buttons.OK_CANCEL);
- if(strRange != "cancel")
- {
- try
- {
- SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
- }
- catch(e) {Browser.msgBox(e.message);}
- }
- }
- function menuItem5(){
- var strRange = Browser.inputBox("Om naar PIE CHARTS te gaan vul dan in A797:", Browser.Buttons.OK_CANCEL);
- if(strRange != "cancel")
- {
- try
- {
- SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
- }
- catch(e) {Browser.msgBox(e.message);}
- }
- }
Add Comment
Please, Sign In to add comment