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?
Code:
Sub UpperSelection()
For Each cell In Selection
If Not cell.HasFormula Then
Cell.Value = UCase(cell.Value)
End if
Next cell
End Sub