TM1 Forum

I have a picklist in Excel reports, it always prompt for the Save dialog box when I close the report in my application.

In the code I have given "Thisworkbook.Saved = True", its work well until I chose the value from picklist. When I choose the value from picklist, its prompt with "Save Dialog box" .

I dont want to show the Save Dialog box. Any Idea how to resolve this?

This isn't necessarily a planning analytics question. If macros are on the table, then put together an On Event routine to handle this (flagging the document.saved=true). Otherwise, stand this up as a template file on the Applications and tell your users to ignore it

Hi ellissj3,

I am not using macros, using Action Reports. I have tried with Workbookbeforeclose Event and sheetchange Event, but its not getting triggered on the picklist value change. Its badly disturbing our application prompting with Save Dialog .. so any other workaround on excel??