Reset Project?

[bobsan42]

Hello guys

Something not really a problem but annoying.
It happened before, but the current situation is as follows:

have a Workbook - sheet with ActiveX buttons for calling some UserForms - it's all in a development stage (so it is frequently tested, changed, code editing, etc.)
When i try to change a form design (View Object) or edit the code or sometimes even when i save the file i get this message and it strated getting on my nerves:
"This Action will reset your project. Continue anyway?"

i got somehow to a conclusion that it is connected with the buttons in the sheet or with the sheet code but not really sure what it is all about.

WTH does this mean? Why i get this message? Any ideas and solutions very much appreciated?

Thanks in advance

 

[ZVI]

Vladimir.

Funny that you should bring this up now because only yesterday I came up with this trick that prevents resetting global variables when adding ActiveX Controls to a worksheet.

Hi Jaafar,

Just having look at you link – very impressive idea to avoid project resetting, thank you!

Issue is old & known but I even haven’t thought to solve it.

Running of your example code in RuntimeControls.xls causes to error on my PC. But it’s because of comma decimal separator instead of the dot char in my system regional settings. Replacing of Left by Str(Left) and the same is for Top/ Width/ Height solves issue and all works well.
I will play more with your code this night (GMT+3).

Thanks again,

 

[Jaafar Tribak]

Hi Jaafar,

Just having look at you link – very impressive idea to avoid project resetting, thank you!

Issue is old & known but I even haven’t thought to solve it.

Running of your example code in RuntimeControls.xls causes to error on my PC. But it’s because of comma decimal separator instead of the dot char in my system regional settings. Replacing of Left by Str(Left) and the same is for Top/ Width/ Height solves issue and all works well.
I will play more with your code this night (GMT+3).

Thanks again,

Thanks vladimir for testing the code.

In case you are interested, I want to let you know that I came up with a much better and much cleaner approach using the CopyMemory API. See here .

Sorry bobsan42 for hijacking this thread