I created the macro in Excel 365 / Windows 10. The macro changes the words in the selection to UPPER CASE, that’s the good news, but then it opens a new spreadsheet (Personal – excel) which I then have to close. Tis quite annoying. I used Bill Jelen’s youtube demo (https://www.youtube.com/watch?v=rrKuasJcmug) to create the macro but it does not operate the same as his. The code I used is shown below. What would you recommend so I stay in the same spreadsheet after the words are changed to upper case?
Sub UpperSelection() For Each cell In Selection If Not cell.HasFormula Then Cell.Value = UCase(cell.Value) End if Next cell End Sub