Compile error: User-defined type not defined

How to fix it?

Thanks.

Please Login or Register  to view this content.

https://social.msdn.microsoft.com/Fo...forum=exceldev

.
Try this :

Please Login or Register  to view this content.

Originally Posted by Logit

.
Try this :

Thanks. So I can change 1 to 15, which is every 15 minutes.

But from the code, how can I know the unit is minute? How to change it to every 5 seconds?

Thanks.

Originally Posted by Logit

.
Try this :

Sorry, I don't think the code works as I expect.

I want to code keeps running, move cursor every X minutes, to avoid screen saver coming up.

Your code is not recurring.

.
The code works as desired. The movement of the cursor is very, very slight. Almost unnoticeable.

Originally Posted by Logit

.
The code works as desired. The movement of the cursor is very, very slight. Almost unnoticeable.

Thanks much!!!!

.
You are welcome .

Originally Posted by Logit

.
You are welcome .

However, moving cursor does not prevent screen saver coming up, if the computer stays inactive for a certain period of time.

.
Change the setting for allowing computer to "sleep" ?

Originally Posted by Logit

.
Change the setting for allowing computer to "sleep" ?

No, it is work laptop, not personal laptop. Have no permission to change setting.

.
Well ... if you are gutsy enough to ignore company policy .... try this resource :

https://www.codeproject.com/Articles...let-it-go-to-s

and click on " Download Exe and checksums - 97.9 KB "


I am certain there are other utilities out there that do the same thing ... search phrase: "vba change Windows sleep setting"