Guest User

Untitled

a guest
Jul 18th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. function onOpen() {
  2. var ui = SpreadsheetApp.getUi();
  3. // Or DocumentApp or FormApp.
  4. ui.createMenu('Inhoudsopgave')
  5. .addItem('Uren', 'menuItem1')
  6. .addSeparator()
  7. .addItem('Marge','menuItem2')
  8. .addSeparator()
  9. .addItem('Omzet','menuItem3')
  10. .addSeparator()
  11. .addItem('Bonus','menuItem4')
  12. .addSeparator()
  13. .addItem('Pie Charts','menuItem5')
  14. .addToUi();
  15. }
  16. function menuItem1(){
  17. var strRange = Browser.inputBox("Om naar UREN te gaan vul dan in A2:", Browser.Buttons.OK_CANCEL);
  18. if(strRange != "cancel")
  19. {
  20. try
  21. {
  22. SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
  23. }
  24. catch(e) {Browser.msgBox(e.message);}
  25. }
  26. }
  27. function menuItem2(){
  28. var strRange = Browser.inputBox("Om naar MARGE te gaan vul dan in A191:", Browser.Buttons.OK_CANCEL);
  29. if(strRange != "cancel")
  30. {
  31. try
  32. {
  33. SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
  34. }
  35. catch(e) {Browser.msgBox(e.message);}
  36. }
  37. }
  38. function menuItem3(){
  39. var strRange = Browser.inputBox("Om naar OMZET te gaan vul dan in A382:", Browser.Buttons.OK_CANCEL);
  40. if(strRange != "cancel")
  41. {
  42. try
  43. {
  44. SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
  45. }
  46. catch(e) {Browser.msgBox(e.message);}
  47. }
  48. }
  49. function menuItem4(){
  50. var strRange = Browser.inputBox("Om naar BONUS te gaan vul dan in A579:", Browser.Buttons.OK_CANCEL);
  51. if(strRange != "cancel")
  52. {
  53. try
  54. {
  55. SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
  56. }
  57. catch(e) {Browser.msgBox(e.message);}
  58. }
  59. }
  60. function menuItem5(){
  61. var strRange = Browser.inputBox("Om naar PIE CHARTS te gaan vul dan in A797:", Browser.Buttons.OK_CANCEL);
  62. if(strRange != "cancel")
  63. {
  64. try
  65. {
  66. SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
  67. }
  68. catch(e) {Browser.msgBox(e.message);}
  69. }
  70. }
Add Comment
Please, Sign In to add comment