I have a template sheet within workbook, and there are formula and reference within the template sheet, but I have manually cleared each green arrow (Ignore Error) in the sheet.
However, when I use VBA to generate a new workbook, and copy the template sheet to new workbook, then use VBA to fill out some data, there are still green arrow in the copied template sheet (in new workbook).
How can I get rid of green arrows in copied template sheet (in new workbook)?
Thanks.
I would say that you can go to configuration and disable it and enable it again if you wish.
See the video.
Ignore All Errors in Excel and Hide the Green Triangles!
Last edited by DJunqueira; 03-22-2024 at 05:13 PM.
Don't know if this is what you're after.
At the start of your code
At the end of your code
Please Login or Register to view this content.
Please Login or Register to view this content.
Experience trumps academics every day of the week and twice on Sunday.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks