Hi,
I am not a vba wizard but usually i know my way a bit. This macro is refreshing sheets which are in the sheetslist, but whilst refreshing i want inform the users what sheet is actually updating..
It seems that Application Screenupdating True towards False isnt working?
Can somebody explain why VBA is looping through the sheets, whilst I changed it to Application.screenupdating = false
Please Login or Register to view this content.
Hi,
Why would you expect to be on sheet1 when you haven't selected/activated sheet1. All you've done is add some information to it. The active sheet is the last one you selected with the objSheet.Select instruction.
But if you want to pass information back to the user why not use the
instruction?Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi,
You have the line that sets screenupdating to True inside your loop. That will have the effect of updating the screen for each sheet. You should only set it to True at the end of your code.
Don
Please remember to mark your thread 'Solved' when appropriate.
Because you are selecting each sheet in turn, but not selecting / activating "Sheet1". So when you switch screenupdating back to true, it displays the currently selected worksheet.
You could modify your code as follows:
Please Login or Register to view this content.
Or you could simply use the statusbar to inform your users of progress.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks for the reply!
Olly, you made me see the lightSetting back to "true", this automatically displays the current "selected" sheet. Its more simple than my thoughts were going tbh!
The With - end With, that does the trick. Thanks for that!
The Application.wait (extra second) was due to its speed. I have an I7 with EVO SSD.. it just goes too quick, it looks like nothing happened!
Which begs the question - why bother updating progress, if it processes that fast?!Originally Posted by Fean
PedantMode:=TrueWhich begs the question - why bother updating progress, if it processes that fast?!
It 'Raises' another question, not 'Begs'. 'Begging the question - petitio principii' is a logical fallacy and something quite different.
PedantMode:=False
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks