New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Win: Protected View causes file to close and reopen #10

Closed
fzumstein opened this Issue Mar 26, 2014 · 1 comment

Comments

Projects
None yet
1 participant
@fzumstein
Member

fzumstein commented Mar 26, 2014

When the samples are downloaded from the internet and depending on the Excel setting under File > Options > Trust Center > Trust Center Settings..., Excel can give you a Security Warning - Enable Content. If that is the case, the excecution of the macro will end with hiding the Workbook completely. In that case, only a restart of Excel helps. A workaround is to close/reopen the Workbook just after enabling the Security Warning.

@fzumstein fzumstein added the bug label Mar 26, 2014

@fzumstein fzumstein changed the title from Protected View causes weird behaviour the very first time the samples are used to Win: Protected View causes weird behaviour the very first time the samples are used Jan 7, 2015

@fzumstein

This comment has been minimized.

Member

fzumstein commented Jan 13, 2015

In the meantime (v0.3.0) this behavior has slightly changed in that the file closes and reopens automatically. If the file is small enough, this is almost not noticeable, but when the file is larger (or the computer slower), this can easily be observed. It also happens under other circumstances, most probably some conflict with add-ins, see: http://stackoverflow.com/questions/27802340/is-there-a-way-to-call-python-with-xlwings-without-reopening-the-excel-file

@fzumstein fzumstein added this to the v0.3.1 milestone Jan 13, 2015

@fzumstein fzumstein changed the title from Win: Protected View causes weird behaviour the very first time the samples are used to Win: Protected View causes file to close and reopen Jan 13, 2015

@fzumstein fzumstein closed this in 6699d9e Jan 14, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment