Can't open any file while running xlsm in excel

Diego Alckmin 1 Reputation point
2020-09-08T17:53:11.673+00:00

I wrote a vba program to control the workers tasks at the office. This is a userform with commandbuttons and comboboxes in it. It was made to stay opened through the day, but when we try to open another excel file (.csv, .xlsx, etc.) it simply doesn't happen. We have to close the userform and therefore the workbook so qe can open the another file. My vba program runs a clock that records all the activities. How can I keep it opened and work with other files at the same time?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,678 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426.3K Reputation points MVP
    2020-09-08T18:38:11.343+00:00

    Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments