Screen Updating

[Evolta]

Hey all,

I have a little problem. When I press my "clear" button it has to delete and reload bunch of information.
While doing so it goes to the sheet in question and shows all actions. I don't want that.

I tried this:
Application.ScreenUpdating = False
(myscript here)
Application.ScreenUpdating = True

But that doesn't do anything. One problem that might cause this is that so happily I am trying to make this work in LibreOffice.
(Reason for this is not because I prefer using LO, but I want to do it for someone else who hasn't got Excel :'/)
All VBA code I use now is supported, but this seems to be difficult.

Any advice other then "just buy excel" or "just write all code in basic" is welcome :D

[ragulduy]

https://bugs.freedesktop.org/show_bug.cgi?id=52603

Perhaps this has something to do with it?

What version of LO are you using?

[Evolta]

https://bugs.freedesktop.org/show_bug.cgi?id=52603

Perhaps this has something to do with it?

What version of LO are you using?

LO 4.1
I think that is exactly the problem. Noticed that more have this problem, but never found a good solution.
In LO BASIC there seems to be a same kind of function, but I have no idea how to get that done.

[Evolta]

Im trying this now:
But it doesn't work at all.
It does call the right code, but just doesn't seem to work


This is in:
documentname.ods - Standard - Module - Module1

Please Login or Register  to view this content.

This is in:
documentname.ods - VBAProject - Module - Module1 - Testen

Please Login or Register  to view this content.

My brain starts to hurt from this problem