Solved: Worksheet focus on unloading modal form

[AJS]

Hi All,

I've got a minor annoyance from some code I use to create and display a chart. The code is set up to select the chart parent just before it ends, so that the user can delete the chart straight away if they want. It was working fine until I implemented a modal userform to give the user the option of entering a caption and/or axis titles, or just skip these and display the chart. When the userform unloads and the chart is created, the focus seems to be off the workbook, as the user now has to click in the workbook before being allowed to either delete the chart or right-click on the chart to edit it. Any ideas as to what might be causing this?

Thanks, Aaron

[Ivan F Moala]

place a



AppActivate ("Microsoft Excel")


after unloading the form

[AJS]

Thanks for that Ivan, it works perfectly!