Тема: ZyXEL Forum – Forums > ZyWALL series

You will now be able to press SHIFT + CTRL + S to run this macro whenever you have the file containing it open. Assigning Short-Cut Keys to Macros in Excel 2007

Common Keyboard ShortcutsShortcut Keys Function Display or hide the Start menu. +BREAK Display the System Properties dialog box. +D Minimizes all Windows and shows the Desktop +E Open Windows Explorer +F Search for a file or folder. +F+CTRL Search for computers. +F1 Display Windows 2000 Help. +L Locks the desktop +M Minimize or restore all windows. +R Open the Run dialog box. +TAB Switch between open items. +U Open Utility Manager ALT+- (ALT+hyphen) Displays the Multiple Document Interface (MDI) child window s System menu. ALT+ENTER View properties for the selected item. ALT+ESC Cycle through items in the order they were opened. ALT+F4 Close the active item, or quit the active program. ALT+SPACEBAR Display the System menu for the active window. ALT+TAB Switch between open items. ALT+Underlined letter in a menu name Display the corresponding menu. BACKSPACE View the folder one level up in My Computer or Windows Explorer. CTRL+A Select all. CTRL+B Bold CTRL+C Copy. CTRL+I Italics CTRL+O Open an item. CTRL+U Underline CTRL+V Paste. CTRL+X Cut. CTRL+Z Undo. CTRL+F4 Close the active document in programs that allow you to have multiple documents open simultaneously. CTRL while dragging an item Copy selected item. CTRL+SHIFT while dragging an item Create shortcut to selected item. CTRL+RIGHT ARROW Move the insertion point to the beginning of the next word. CTRL+LEFT ARROW Move the insertion point to the beginning of the previous word. CTRL+DOWN ARROW Move the insertion point to the beginning of the next paragraph. CTRL+UP ARROW Move the insertion point to the beginning of the previous paragraph. CTRL+SHIFT with any of the arrow keys Highlight a block of text. DELETE Delete. SHIFT+DELETE Delete selected item permanently without placing the item in the Recycle Bin. ESC Cancel the current task. F1 Displays Help F2 Rename selected item. F3 Search for a file or folder. F4 Display the Address bar list in My Computer or Windows Explorer. F5 Refresh the active window. F6 Cycle through screen elements in a window or on the desktop. F10 Activate the menu bar in the active program. SHIFT+F10 Display the shortcut menu for the selected item. CTRL+ESC Display the Start menu. SHIFT+CTRL+ESC Launches Task Manager Underlined letter in a command name on an open menu Carry out the corresponding command. RIGHT ARROW Open the next menu to the right, or open a submenu. LEFT ARROW Open the next menu to the left, or close a submenu. SHIFT with any of the arrow keys Select more than one item in a window or on the desktop, or select text within a document. SHIFT when you insert a CD into the CD-ROM drive Prevent the CD from automatically playing. -------------------------------------------------------------------------------- Dialog box keyboard shortcuts Shortcut Keys Function CTRL+TAB Move forward through tabs. CTRL+SHIFT+TAB Move backward through tabs. TAB Move forward through options. SHIFT+TAB Move backward through options. ALT+Underlined letter Carry out the corresponding command or select the corresponding option. ENTER Carry out the command for the active option or button. SPACEBAR Select or clear the check box if the active option is a check box. Arrow keys Select a button if the active option is a group of option buttons. F1 Display Help. F4 Display the items in the active list. BACKSPACE Open a folder one level up if a folder is selected in the Save As or Open dialog box. -------------------------------------------------------------------------------- Windows Explorer keyboard shortcuts Shortcut Keys Function CTRL+PLUS on numeric keypad (+) Automatically resize the columns in the right hand pane END Display the bottom of the active window. HOME Display the top of the active window. NUM LOCK+ASTERISK on numeric keypad (*) Display all subfolders under the selected folder. NUM LOCK+PLUS SIGN on numeric keypad (+) Display the contents of the selected folder. NUM LOCK+MINUS SIGN on numeric keypad (-) Collapse the selected folder. LEFT ARROW Collapse current selection if it s expanded, or select parent folder. RIGHT ARROW Display current selection if it s collapsed, or select first subfolder. -------------------------------------------------------------------------------- Natural Keyboard shortcuts You can use the following keyboard shortcuts with a Microsoft Natural Keyboard or any other compatible keyboard that includes the Windows logo key () and the Application key (). Shortcut Keys Function Display or hide the Start menu. +BREAK Display the System Properties dialog box. +D Minimizes all Windows and shows the Desktop +M Minimize or restore all windows. +E Open My Computer. +F Search for a file or folder. CTRL+ +F Search for computers. +F1 Display Windows 2000 Help. +L Locks the desktop +R Open the Run dialog box. +TAB Switch between open items. Display the shortcut menu for the selected item. +U Open Utility Manager -------------------------------------------------------------------------------- Accessibility Options keyboard shortcuts Shortcut Keys Function Right SHIFT for eight seconds Switch FilterKeys on and off Left ALT +left SHIFT +PRINT SCREEN Switch High Contrast on and off Left ALT +left SHIFT +NUM LOCK Switch MouseKeys on and off SHIFT five times Switch StickyKeys on and off NUM LOCK for five seconds Switch ToggleKeys on and off +U Open Utility Manager -------------------------------------------------------------------------------- Help Viewer keyboard shortcuts If your mouse is unavailable or if you prefer using your keyboard, you can use the following keyboard commands to navigate within the Help Viewer. To expand the headings below using the keyboard, press F6 to switch from the Help navigation pane to the topic pane. Press TAB to select the desired keyboard shortcut heading, and then press ENTER to expand the listing. Shortcut Keys Function ALT+SPACEBAR Display the system menu. SHIFT+F10 Display the Help Viewer shortcut menu. ALT+TAB Switch between the Help Viewer and other open windows. ALT+O Display the Options menu. ALT+O, and then press T Hide or show the navigation pane. CTRL+TAB Switch to the next tab in the navigation pane. CTRL+SHIFT+TAB Switch to the previous tab in the navigation pane. UP ARROW Move up one topic in the table of contents, index, or search results list. DOWN ARROW Move down one topic in the table of contents, index, or search results list. PAGE UP Move up one page in the table of contents, index, or search results list. PAGE DOWN Move down one page in the table of contents, index, or search results list. F6 Switch focus between the navigation pane and the topic pane. ALT+O, and then press R Refresh the topic that appears in the topic pane. UP ARROW or DOWN ARROW Scroll through a topic. CTRL+HOME Move to the beginning of a topic. CTRL+END Move to the end of a topic. CTRL+A Highlight all text in the topic pane. ALT+O, and then press P Print a topic. ALT+O, and then press B Move back to the previously viewed topic. ALT+O, and then press F Move forward to the next (previously viewed) topic. ALT+F4 Close the Help Viewer. Contents tab keyboard shortcuts Shortcut Keys Function ALT+C Display the Contents tab. RIGHT ARROW Open a book. LEFT ARROW Close a book. BACKSPACE Return to the previous open book. UP ARROW or DOWN ARROW Select a topic. ENTER Display the selected topic. Index tab keyboard shortcuts Shortcut Keys Function ALT+N Display the Index tab. UP ARROW or DOWN ARROW Select a keyword in the list. ALT+D or ENTER Display the associated topic. Search tab keyboard shortcuts Shortcut Keys Function ALT+S Display the Search tab. ALT+L Start a search. ALT+D or ENTER Display the selected topic. Favorites tab keyboard shortcuts Shortcut Keys Function ALT+I Display the Favorites tab. ALT+A Add a topic to the Topics list. ALT+P Select a topic in the Topics list. ALT+R Remove a topic from the Topics list. ALT+D Display a topic from the Topics list.

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Do you want a button to run a VBA macro in excel?
Remembering shortcuts for each and every macro is not easy so you probably required buttons with label to recognize macros and easily run them. Today we will learn how we can assign a VBA macro to a button in worksheet. We will learn it in just three easy steps. Although you can Add or assign a button to macro in almost all version of MS Excel like Excel 20013, 2010, 2007 and 2003 but we are considering Excel 2007 menu to explain example here.

Step# 1: Go to Insert menu and click on the shapes then choose Rectangle shape and give it name by edit text in mouse right click option.

If you add the E3 license, you get EVERYTHING that comes with E3, if that’s what you need, great, but what if you ONLY want SharePoint, and not Lync, email, etc??

This article was really helpful:  

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Do you want a button to run a VBA macro in excel?
Remembering shortcuts for each and every macro is not easy so you probably required buttons with label to recognize macros and easily run them. Today we will learn how we can assign a VBA macro to a button in worksheet. We will learn it in just three easy steps. Although you can Add or assign a button to macro in almost all version of MS Excel like Excel 20013, 2010, 2007 and 2003 but we are considering Excel 2007 menu to explain example here.

Step# 1: Go to Insert menu and click on the shapes then choose Rectangle shape and give it name by edit text in mouse right click option.

If you add the E3 license, you get EVERYTHING that comes with E3, if that’s what you need, great, but what if you ONLY want SharePoint, and not Lync, email, etc??

This article was really helpful:  

You can customize keyboard shortcuts (or shortcut keys) by assigning them to a command, macro, font, style, or frequently used symbol. You can also remove keyboard shortcuts. You can assign or remove keyboard shortcuts by using just the keyboard , or by using a mouse.

Any keyboard shortcuts that are currently assigned to that command or item appear in the Current keys box, or below the box with the label Currently assigned to.

sheet one: version | grammar and execution | variables and expressions | arithmetic and logic | strings | regexes | dates and time | arrays | dictionaries | functions | execution control | exceptions | threads

sheet two : streams | asynchronous events | files | file formats | directories | processes and environment | option parsing | libraries and namespaces | objects | inheritance and polymorphism | reflection | net and web | gui | databases | unit tests | logging | debugging

6

Private Sub Form_KeyPress(KeyCode As Integer) MyChar = Chr(KeyCode) Select Case (MyChar) Case 13 Enter Key Form_Click() End Select End Sub

Click here assigning function keys

You will now be able to press SHIFT + CTRL + S to run this macro whenever you have the file containing it open. Assigning Short-Cut Keys to Macros in Excel 2007

8

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Do you want a button to run a VBA macro in excel?
Remembering shortcuts for each and every macro is not easy so you probably required buttons with label to recognize macros and easily run them. Today we will learn how we can assign a VBA macro to a button in worksheet. We will learn it in just three easy steps. Although you can Add or assign a button to macro in almost all version of MS Excel like Excel 20013, 2010, 2007 and 2003 but we are considering Excel 2007 menu to explain example here.

Step# 1: Go to Insert menu and click on the shapes then choose Rectangle shape and give it name by edit text in mouse right click option.

Would someone tell me what the function keys on the keyboard are ? just cant figure them out. Thanks , Sandavis - 72044

10

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Default window Assigned Funtion Keys F1 - Help F2 - Renames selected file F3 - Opens the file search box F4 - Opens the address bar in Windows Explorer F5 - Refreshes the screen in Windows Explorer F6 - Navigates between different sections of a Windows Explorer window F8 - Opens the start-up menu when booting Windows F11 - Opens full screen mode in Windows Explorer Fooling windows Here s an idea that I ve found to be handy. Right click a shortcut or an executable to your favorite program. Select properties. Left click in the shortcut section and press the F1 key. Click OK and then the next time you want to open that program all you will need to do is press the F1 key. You can, if you want, press Shift + F1 or any other combination of keys. This will reassign the function key to that shortcut. See Source link To completely remap or disable any key use this free tool http://www.randyrants.com/sharpkeys/ Read the FAQ s Hope this helps

12

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can't figure the other keys out

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Do you want a button to run a VBA macro in excel?
Remembering shortcuts for each and every macro is not easy so you probably required buttons with label to recognize macros and easily run them. Today we will learn how we can assign a VBA macro to a button in worksheet. We will learn it in just three easy steps. Although you can Add or assign a button to macro in almost all version of MS Excel like Excel 20013, 2010, 2007 and 2003 but we are considering Excel 2007 menu to explain example here.

Step# 1: Go to Insert menu and click on the shapes then choose Rectangle shape and give it name by edit text in mouse right click option.

If you add the E3 license, you get EVERYTHING that comes with E3, if that’s what you need, great, but what if you ONLY want SharePoint, and not Lync, email, etc??

This article was really helpful:  

You can customize keyboard shortcuts (or shortcut keys) by assigning them to a command, macro, font, style, or frequently used symbol. You can also remove keyboard shortcuts. You can assign or remove keyboard shortcuts by using just the keyboard , or by using a mouse.

Any keyboard shortcuts that are currently assigned to that command or item appear in the Current keys box, or below the box with the label Currently assigned to.

14

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

15

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

16

Would someone tell me what the function keys on the keyboard are ? just cant figure them out.

Thanks for answering so quick I have a HP Pavilion dv7 notebook , I would guess fn plus f3 is for the internet but I just can''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''t figure the other keys out

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Suppose that you ve written a whizzy macro (called, oddly, SpiderPig ), and you want to find an easy way to run it.

Every laptop, or rather every keyboard comes with a set of Function Keys which cater to special functions. And if you know how to use them optimally you might just enjoy using the keyboard. Though F1 through F12 have some default primary and secondary (in combination to the Fn key) features, they can be used well in combination with keys like Ctrl and Alt.

Today GT takes pleasure in listing down the common as well as the best uses of these amazing set of keys. Now, in many keyboards each of these keys will have additional set of functions like multimedia, sleep/wake et al. We won’t be talking about that here. We will talk about how to generally use them across browsers, Windows and mainly MS Office. Here we go.

Note : This function assigns new keys to the elements in array. It will remove any existing keys that may have been assigned, rather than just reordering the keys.

Note : Like most PHP sorting functions, sort() uses an implementation of Quicksort. The pivot is chosen in the middle of the partition resulting in an optimal time for already sorted arrays. This is however an implementation detail you shouldn t rely on.

Do you want a button to run a VBA macro in excel?
Remembering shortcuts for each and every macro is not easy so you probably required buttons with label to recognize macros and easily run them. Today we will learn how we can assign a VBA macro to a button in worksheet. We will learn it in just three easy steps. Although you can Add or assign a button to macro in almost all version of MS Excel like Excel 20013, 2010, 2007 and 2003 but we are considering Excel 2007 menu to explain example here.

Step# 1: Go to Insert menu and click on the shapes then choose Rectangle shape and give it name by edit text in mouse right click option.

If you add the E3 license, you get EVERYTHING that comes with E3, if that’s what you need, great, but what if you ONLY want SharePoint, and not Lync, email, etc??

This article was really helpful: