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?
Picklist in reports
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
-
- Posts: 54
- Joined: Tue Jun 15, 2010 1:43 pm
- OLAP Product: Cognos TM1
- Version: 9.0 - 10.2
- Excel Version: 2010
Re: Picklist in reports
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
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
Re: Picklist in reports
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??
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??