Skip to content
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
Closed

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

fzumstein opened this issue Mar 26, 2014 · 1 comment

Comments

@fzumstein
Copy link
Member

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 Protected View causes weird behaviour the very first time the samples are used Win: Protected View causes weird behaviour the very first time the samples are used Jan 7, 2015
@fzumstein
Copy link
Member Author

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 Win: Protected View causes weird behaviour the very first time the samples are used Win: Protected View causes file to close and reopen Jan 13, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant