Need help with a couple simple VBA macros for Excel 97.
Posted by Jaakob on January 19, 2001 5:58 AM
Im working in Excel 97 on Windows NT4.0.
Im new to VBA so I only understand enough to patch things together and make minor edits to recorded macros.
I needed to Unprotect all worksheets in a variety of Excel files, and based on a couple other similar examples I found in this forum, I managed to cobble the following macro together. It seems to work okay. I'm not sure if it's the best way. Any suggestions?
' UnProtectAll Macro
' Macro recorded 1/17/01 by Jaakob
For Each WS In Worksheets
More importantly, heres another, but related, problem I need to solve but havent yet figured out. I need to SelectAll and then impose "Normal font" for every worksheet in a workbook. Can anyone help me out?
Thanks in advance for any help you can give me.