User loginNavigation |
Excel - Merge Cells into OneThis code will convert the cells you have selected into one cell. Public Sub MergeCells() The sDELIM can be changed to insert something else to break up the combined text, numbers, etc. Excel - Remove Hyperlinks - LinksThis is a major bit of coding by me, so many spreadsheets refer to external data, links, files and if you are editing it, just one click and it tries to open it. So annoying. This will copy everything but the links to another sheet in the same Workbook. Tried and tested. I have search the internet and not found anything like this that works. Sub RemoveLinks() Excel - Remove All FiltersCode to remove all filters. Can save time when you have a large spreadsheet and can't find which filter is on. Sub removeallfilters() Excel - Activate FiltersThe following code activates filters. Sub viewrfa() field = column number starting from the left ie E = 5 Excel - Easy Cell ColoursBy using VBA you can define the colours of your choice and make it easier to change them for your users. First Section is to create a menu. Sub AddMenus() Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar") Set cbcCutomMenu = cbMainMenuBar.Controls.Add(Type:=msoControlPopup, Before:=iHelpMenu) Excel - Create Menu - Week NoCode to create a menu of your choice in Excel. This example creates 2 menus. By using the & symbol before the menu name you create Keyboard Shortcuts. One of the menu's is a blank menu as it displays the current week no. You can get the menu to automatically load by putting the code in the Workbook_Open() Sub. Sub AddMenus() |