Excel VBA Tips: Stop Users from Adding Sheets

Excel VBA Tips: Stop Users from Adding Sheets Do you have a spreadsheet that you want to stop users from adding sheets to? Of course, you could lock the workbook using the “protect workbook” feature and ensuring that the protect structure is selected. However, say that you need to protect the workbook via vba. Place…

Read More

Excel VBA Tips: Convert Number to Text

Excel VBA Tips: Convert Number to Text I have covered how to do this using worksheet formulae, but it can also be done using vba. If your variable (that is a number) is called Number, to convert this to text, use the following code: Number = CStr(Number) It will now be stored in text format.…

Read More

Excel Worksheet Tips: Keyboard Shortcuts

Excel Worksheet Tips: Keyboard Shortcuts I was searching for a particular shortcut but unfortunately I was unable to find the one I was looking for; however I have found many more. Check out all these useful shortcuts here. Come check out the directory for the rest of my excel tips! Submeg IT

Read More