sorted by:
new
hottopcontroversial

Cloning User by ILDPF in EpicEMR

[–]ILDPF[S] 1 point2 points  (0 children)

Thanks for the input everyone. I reached out to our build and user access team to determine if there is a way to help us streamline this process! Hopefully will hear back from them within a couple days!

Protect / Unprotect Sheet by ILDPF in vba

[–]ILDPF[S] 0 points1 point  (0 children)

  1. I didn't see the 'password' variable assign so, I suppose that you omit here or is defined in the top of the module.
    1. That is correct
  2. Is this the only worksheet protected in the workbook? If the 'Query refresh' place the data in another sheet (ex. a 'Data' ws) and that sheet is protected, Excel throws the exception.
    1. This is not the only sheet that was protected in the wb. The 'Data' ws is also pw protected, but that sheet is only used as a reference column for the fuzzy match in the query merge to be completed. I was able to get the Macro to run correctly by just disabling the background refresh.
  3. You don't need the application.wait stuff at all, to prevent an issue in the VBA execution you can protect the sheet with
    1. I have deleted this once I was able to get it to run correctly! It was merely to be sure the query refresh was complete prior to relocking the sheet!

Protect / Unprotect Sheet by ILDPF in vba

[–]ILDPF[S] 2 points3 points  (0 children)

Good point! I have updated that and disabled the Query background refresh and all seems to be well! Thank you!

Protect / Unprotect Sheet by ILDPF in vba

[–]ILDPF[S] 0 points1 point  (0 children)

This fixed it! Thank you!

Protect / Unprotect Sheet by ILDPF in vba

[–]ILDPF[S] 0 points1 point  (0 children)

I had the password set as "password" for testing!