I want my formatting macro to run on a different workbook than the one the macro is stored in. So far I have only this code:
Application.ScreenUpdating = False
If ActiveWorkbook.Name <> ThisWorkbook.Name Then
--Do the things i want--
End If
Do i need to have the Dim ___ As things to go with it?