Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Simon FERRAND (SimonF37)
Sopra Steria Group

Sopra Steria Group
FR
SimonF37 Member since 2013 7 posts
Sopra Steria Group
Posted: Mar 10, 2020
Last activity: Mar 11, 2020
Posted: 10 Mar 2020 13:50 EDT
Last activity: 11 Mar 2020 3:38 EDT
Closed

Case Type Backlog Tool Macro error

Hi,

 

There is an error "1004" (microsoft visual basic) when manipulating Case Type Backlog Tool (platform or application specific (customer service for example)). I suspect that this is related to macros in the excel file...

Does someone find a resolution or a workaround to this trouble ?

 

Thanks in advance.

To see attachments, please log in.
Project Delivery

Posted: 4 years ago
Posted: 11 Mar 2020 3:38 EDT
Shiva Rakshith S (Rakshith) Technical Solutions Engineer
Pegasystems Inc.
IN

This error is caused by a security option in Excel meant to deliberately lock out programmatic access to Microsoft Visual Basic for Applications (VBA) unless a user chooses to permit such access.

To resolve:

  1. Open a blank workbook in Excel.
  2. Go to File > Options > Trust Center
  3. Click on Trust Center Settings... 
  4. Under Macro Settings, make sure Trust access to the VBA project object model is checked. 
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice