Hello folks,
I have a final request in order to complete my project.
1). How do i run all macro on every minute in a single workbook?
2). How to ensure that my dashboard sheet will not close or locked after a certain period of no usage?
Please share some insight and thanks in advance.
on your 1st query: try this pattern & change the timing as you required
Please Login or Register to view this content.
Regards,
Thangavel D
Appreciate the help? CLICK *
Um.....you might also wanna read up on application.ontime or you stand a good chance of configuring this workbook to open itself every minute, driving you nuts.
https://docs.microsoft.com/en-us/off...ication.ontime
Hi,
Are you wanting to run several macros all at the same time or several macros in sequence automatically and then continue to run the sequence of macros every minute?
If the former then AFAIAA you can't.
If the latter then if will depend entorely on how long the sequence takes to run. Might they take in total longer than 1 minute to run?
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.
This'll help you out also:
http://www.snb-vba.eu/VBA_Application.OnTime_en.html
Hi All,
Thanks for your feedback.
I would like to run all macros at the the same at every minute.
Also, to ensure that my pc/laptop display screen will not lock after certain time of no usage.
I'm facing this error.
Any idea on why?
Macro error.PNG
double check the macro names of your macro or the macro in your pc/machine is disabled.
You used the same code given in post#2..!!Originally Posted by Sharonjit
that is sample of running the code based on timer, you need to modify it for your requirement.
Just to be absolutely clear, do you want all macros running in parallel or sequentially? i.e at any instant do you expect all macros to be processing their code?
Hi Richard,
Yes, running in parallel once i open my workbook.
Currently, a pop put window panel will request to key in the password every time.
I would like to eradicate this pop out window panel and will be able to run all macro in parallel once i open my workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks