View Single Post
 
Old 03-11-2023, 03:59 AM
ChrisGreaves ChrisGreaves is offline Windows 10 Office 97-2003
Novice
 
Join Date: Nov 2022
Location: Bonavista, Newfoundland
Posts: 22
ChrisGreaves is on a distinguished road
Default

Quote:
Originally Posted by NicoleJones View Post
Is it possible to write VBA code to detect the style currently used?
Hi Nicole. I have a slew of utility procedures for manipulating styles. The attached function may give you some ideas.
This is a self-testing function; drag the commented macro outside of the function then de-comment the macro. Run the test macro until it works, then make changes to the function and insert new test lines and rerun the test macro. Comment the macro and drag it back into the function.
Cheers, Chris
Attached Files
File Type: txt Public Function blnStyleFoundInUseI.txt (1.5 KB, 13 views)
Reply With Quote