Quote Originally Posted by GTO View Post
Okay, thank you for testing. I do not think it (StyleTypes) is a userform. I am logging out shortly, but would it be possible to upload the workbook with the code in it? Scrub any sensitive data of course...
ACK! I was wrong; it is a userform. See below...

Quote Originally Posted by sollijones View Post
Hello Community,

We are experiencing an issue with a delivered PeopleSoft nVision StyleSheets macro that was probably carried over from Excel 2003 or earlier. Our nVision environment is now using Excel 2007. However, many users have Excel 2010 or 2016 installed on their computers.

The StyleSheeets macro is used to format PS nVision layouts (an Excel file). The StyleSheets templates are saved under a specific directory that is identified in the configuration for nVision in the PeopleSoft Application Designer program.

I have a very limited understanding of VBA and would greatly appreciate some guidance.

The run-time error 445 is first generated when the macro to Open Style Sheets is selected. When debug is selected, the "Unload StyleTypes" line is highlighted -
Activates the Style Sheet creation wizard
...

After additional research, it was discovered that FileSearch is usually the cause of this run-time error. When the code was searched for FileSearch, the following code was found
Although it appears expired, I did note this in the workbook: '* Copyright (c) 1988-1999 PeopleSoft, Inc. All Rights Reserved. *

You mention that you are now using Excel2007, with some using newer versions than this. I believe that FileSearch was depreciated (a fancy way of saying it no longer works) in 2007 and thereafter. I would contact the vendor or PeopleSoft for a newer version of this workbook. I would be confident that they have long since updated the workbook to use another method.

Sorry for missing what you clearly stated in your first post...

Mark