Worksheet not active after dialog box closes

[SteveRMS]

I'm using VBA to display a dialogue box (user form). When I close the dialogue box, the Excel worksheet is not active - the title bar is dimmed. I need to click somewhere on the worksheet to make it active.
I've tried lots of VBA commands to achieve this without success.
What am I missing?

 

[Michael M]

Hi Steve
Did you put

unload frmName 'whatever your frmname is

at the end of your code ?
Are you really in RMS ?

 

[SteveRMS]

Hi Steve
Did you put

unload frmName 'whatever your frmname is

at the end of your code ?
Are you really in RMS ?

Yes, I put Unload Me in the cmdOK_Button_Click subroutine in the user form.
Yes, I work for RMS at Argyle Street

 

[Michael M]

Some comments here from Tom Ogilvy
Activate Excel worksheet after showing a user form ? | PC Review

In particular, Post #6

Parkes Regional Office....but currently on LSL

 

[SteveRMS]

Some comments here from Tom Ogilvy
Activate Excel worksheet after showing a user form ? | PC Review

In particular, Post #6

Parkes Regional Office....but currently on LSL

Thanks for the suggestion. I checked my code but I don't use the setfocus command.
However I did use it a few weeks ago to try to solve the problem. Here the methods I've tried:
stgTitle = "Microsoft Excel - " & stgTitle
AppActivate stgTitle
Workbooks(stgTitle).Worksheets("Risk register").Activate
Sheets("Risk register").Select
Workbooks(stgTitle).Worksheets("Risk register").SetFocus
CommandBars("ProjectPack risk register").Enabled = True
Application.Run ("PP_RR_Template_Toolbar.PP_RR_Toolbar_Create")
Cells(1, 1).Select

Any other ideas?

 

[Michael M]

Not until I get Excel back up !
What is the current code that's "not working", can you post it, so that hopefully someone else may be able to jump in and assist !

 

[SteveRMS]

Not until I get Excel back up !
What is the current code that's "not working", can you post it, so that hopefully someone else may be able to jump in and assist !

The code for showing and hiding the dialogue box is straight forward.
The following code displays the dialogue box:
frmPP_RR_Display_Options.Show
The following code is within the user form:
Me.Hide
Unload Me
There's lots of other subsequent code to handle the options selected by the user.

 

[Michael M]

If you are within the userform code...Unload.Me should work fine
But if you aren't you need to refer to the form exactly...Unload Usrfrmname

Also, it sounds like there is still code running in the background, or the Excel application is still running (title bar dimmed)

 

[SteveRMS]

If you are within the userform code...Unload.Me should work fine
But if you aren't you need to refer to the form exactly...Unload Usrfrmname

Also, it sounds like there is still code running in the background, or the Excel application is still running (title bar dimmed)

Thanks for the ideas.
The Unload.me is within the userform code.
I read through the code again but I can't see any reason why anything might be running in the background.
Is there something in the userform properties that could be causing this problem?

 

[Michael M]

No, once unloaded, that should be it !!
Without seeing the rest of the code, it's hard to guess what it could be !!
Have you tried putting breakpoints in the code and / or stepping through manually.