On open event

[PLD60]

I have the following code to open a form when the workbook opens.

Please Login or Register  to view this content.

It worked great until yesterday on a Surface Pro and it works on my desktop. Yesterday the Surface Pro did an update. What would have changed to make this not work? When opened the User form does not open.

[kev_]

What happens during all the updates is one of life's big mysteries.
Your problem may be nothing to do with the update (a coincidence)

Please create a new workbook on the Surface Pro
- add the above workbook_open event macro
- create a simple userform with same name

Save the file
Close it
Open it

Does it work?

[PLD60]

kev_

Thanks for the reply. It does not.

I tried a simple

Please Login or Register  to view this content.

in the on open event and it works sometimes, although right now I can not get it to work.

[MarvinP]

Hey PDL,

You might need to fully qualify your "Worksheets("Building")" as having more than one workbook open at a time, Excel wouldn't know which workbook you were using to look for that "Building" sheet. Something like debug.print ActiveWorkbook.Name might show you the problem.

[kev_]

Has Excel on Surface Pro lost its ability to trigger events possibly?

Here's a quick test:
Put code below in a SHEET module and select a cell in that sheet
Does the message pop up?

Please Login or Register  to view this content.

[MarvinP]

@kev - I also wonder if upgrades to OneDrive and the way files are stored makes a difference. If the OP opened the file from OneDrive and had a copy on his hard drive, what is Excel supposed to do? Collaboration is a big deal now with upgrades in Microsoft land. Perhaps the file is already open by a colleague and OnOpen is confused??

[kev_]

@MarvinP
Yes - life used to be much simpler when we all sat up our own little tree
Children playing with the same toy often leads to tears - file sharing is similar...

[MarvinP]

I still think the OP's code is looking at the wrong workbook as s/he has many opened at the same time. I make that "Fully Qualified" mistake in my code too often.

[kev_]

@MarvinP I hope you are correct - it's the simplest answer to the puzzle

[PLD60]

So, the Message Box "Hello" test works.

I have taken the If statement out and just have

Please Login or Register  to view this content.

In the On Open event.

If I restart the Surface the first time I open the Workbook it works properly and opens the User Form. I close the Workbook and then every time I open after that the User Form does not open.

No other version in OneDrive or Dropbox. Not on any other computer.

[MarvinP]

Open your task manager using Ctrl+Alt+Del and see what other software is hogging/storing/using recourses. Stop some and try to reopen your excel file. I'm guessing some cute "fast start" software is keeping Excel from thinking it is opening a new file as it is already in memory (or something like that).

Is this machine a full windows machine? Microsoft came out with a Window 10 S version that wouldn't run old apps. Are you using that OS?

[PLD60]

Windows 10 Pro

[PLD60]

Nothing seems to be helping. What would prevent any On Open event from working? All other Macros and code are working. If I run the code in the VBA editor everything works as it should.

[kev_]

Did you try what I suggested in post#5?

[PLD60]

kev_, yep nothing works in the

Private Sub Workbook_Open()

[xlnitwit]

Hi,

What if you move the code to a normal module and use Auto_Open

Please Login or Register  to view this content.

[kev_]

Did you try what I suggested in post#5?

Kev_, yep nothing works in the
Private Sub Workbook_Open()

I do not understand your answer

suggestion in post#5 was:
Put code below in a SHEET module and select a cell in that sheet
Does the message pop up?

Please Login or Register  to view this content.

...which does not involve Workbook Open..

[PLD60]

xlnitwit, This seems to work. Any Idea why?

[xlnitwit]

That suggests, and this is what kev_ was trying to establish too, that you have some code that is disabling events and not re-enabling them.

[PLD60]

Why would that only happen on the Surface Pro and not on my desktop unit?

[xlnitwit]

Perhaps you have an add-in or other program installed on the Surface that is not on the Desktop and which is interfering.