Excel Performance issues using VBA and ActiveX buttons

[grabrail]

HI

I have a workbook that has extensive vba code to do multiple things in the background, and a number of ActiveX buttons with code assigned to them.

Sometimes when clicking the buttons there is no response, and I have to change worksheet and go back t the worksheet with the buttons on them to get them to respond. Its like Excel is having perfomance issues.

one of the buttons is a validat button which goes and checks multiple cells on different worksheets to ensure data has been entered, another button is a save button which saves the workbook to a specific location with specific filename.

The buttons actually work fine and do the job they are meant to do, and pretty quickly, its just sometimes there is no respnse.

My laptop is new and has lots of memory and an i7 processor

Any ideas or thoughts as to why this would happen and how to reduce or stop it from happening?

 

[grabrail]

HI

I have a workbook that has extensive vba code to do multiple things in the background, and a number of ActiveX buttons with code assigned to them.

Sometimes when clicking the buttons there is no response, and I have to change worksheet and go back t the worksheet with the buttons on them to get them to respond. Its like Excel is having perfomance issues.

one of the buttons is a validat button which goes and checks multiple cells on different worksheets to ensure data has been entered, another button is a save button which saves the workbook to a specific location with specific filename.

The buttons actually work fine and do the job they are meant to do, and pretty quickly, its just sometimes there is no respnse.

My laptop is new and has lots of memory and an i7 processor

Any ideas or thoughts as to why this would happen and how to reduce or stop it from happening?

Further to this, it seems like it happens most when a button has been pressed and does what it needs to do, then you click one of the other buttons, this seems to be the most times when the problem is happening

 

[NdNoviceHlp]

Seems like a focus issue. Does your code effect sheets other than the sheet with the buttons? Trial adding either YourButtonSheetName.Select or YourButtonSheetName.Activate to the end of your button(s) code. HTH. Dave