Delay workbook opening to avoid protection mode error

[jaryszek]

Hi Guys,

i have an issue while workbook is opened (error) in protected mode.

The problem was described here:

https://support.microsoft.com/en-us/...-exiting-prote

I added new Class1 and put the code from link there but i do not know how to test it, how to invoke protected mode to test it?
It sometimes appearing for me , sometimes not.

Please help - Did i do this properly by adding code into Class1 class?

Please help
Jacek

[AliGW]

Is this the same as your other thread?

[jaryszek]

Which thread?

Jacek

[AliGW]

This one: https://www.excelforum.com/excel-pro...-workbook.html

[jaryszek]

Nope,

why i would create 2 the same theads?

From Link is about unlocking VBE project password.
From this topic is about protected mode and opening excel which is causing workkook_activate event to fail...

Jacek

[AliGW]

That's why I am asking - thanks for clarifying.

[jaryszek]

Hi Guys,

anyone was trying to use the class from link?
It is working for you?

Jacek

[jaryszek]

Anyone please?

Can help with implementation which will work?

Jacek

[jaryszek]

Hi,

Bump, can anybody help?

Jacek

[jaryszek]

Anyone please help

Jacek

[jaryszek]

Bump,

anyone can help?

Jacek

[romperstomper]

You haven't given enough information. Where is the code that is failing?

[jaryszek]

Hi rory,

I do not know how to implement the code from microsoft link above:

Please Login or Register  to view this content.

I added code into class module.
but this is not working.
It is not catching protected mode.

Best,
Jacek

[romperstomper]

You didn't answer my question. Where is the code that is failing?In the same workbook, in an add-in, in some other program...?

[jaryszek]

In the same workbook.

It is workbook open event:

Please Login or Register  to view this content.

Best,
Jacek

[romperstomper]

It says quite clearly in that article that it won't work in a Workbook_Open event. Since the code in that sample is for an external app, you don't need a separate class (your ThisWorkbook is already a class). You need to implement a similar hand off to a Workbook_Activate event instead, or just move your code to that event if you can.

[jaryszek]

Hmm let me think how to solve this on example.

I will try to add something to google drive and open in protected view to test.

I will let you know about results,
Best,
Jacek

[jaryszek]

Ok Guys,

I am returnng back with feedback and asking for your confirmation and suggestions.

I created 2 workbooks:

TestWithoutHandler:

Please Login or Register  to view this content.

which i put on google disc:
https://drive.google.com/open?id=10c...yj6d5jPZXDMr1n

Also i created workbook with handler:

Please Login or Register  to view this content.

Google Disc:
https://drive.google.com/open?id=1RX...A1QN8Z_DOyiGuu

i am also adding them as attachment.
To invoke protected mode you can upload these workbooks into google drive and just download, after opening it will be opened in protected mode.

The second workbook with handler seems to be working fine. The first one throws error on workbook.activate method (like in my original workbook).

Can anybody confirm that this code is enaugh to solve the issue in this case ?:

Please Login or Register  to view this content.

It is very interesting.

Best wishes,
Jacek

[jaryszek]

Ok i checked on my main workbook (17 MB) and this is not working...

I think here:

Please Login or Register  to view this content.

i should have some kind of loop in order to make this work to TRULY delay workbook opening.
Can anybody advice?

I do not catch how the original code can delay workbook opening. It is just changing boolean to TRUE...

Jacek

[romperstomper]

You didn't implement the suggested code as you don't have a Workbook_Activate event that I can see.

[jaryszek]

Hi,

because this is the same instance. I tried to do as one instance.
How can i do this?

Jacek

[romperstomper]

The point is that if the workbook is in protected mode, the code simply sets a Boolean flag (your line is commented out, so it doesn't actually do anything) and then you have an additional Workbook_Activate event that only does anything if that flag is set (it also sets it to false so it won't run again if you, say, switch between workbooks).

[jaryszek]

thanks rory.

so what was wrong in original code?
I tried to change it and now this is not ok.
So i should have workbooks_open event? Or not?

What should i do?

Can you please help?
Where should i put Application.Event?

i put all code to the ThisWorkbook class:

Please Login or Register  to view this content.

This is ok?

edit2: The code above pasted into ThisWorkbook class is not working...

Jacek

[romperstomper]

You don't need all that if the code is in the workbook being opened. Just:

Please Login or Register  to view this content.

[jaryszek]

You are MAster!!!!

thank you Rory, respect!

Jacek