user accessibility

Good afternoon A bit of a strange one on a process I'm currently changing. Currently, the business emails payroll data to the payroll team in a variety of weird and wonderful formats for them to manually process. I've streamlined the process by standardising the submission using VBA and...

Hi there, I am new to VBA and just used YouTube to create a calculator for work. My colleagues and seniors (who have seen it) love what Excel can do as it will save so much time. In order for the company to want to proceed it requires testing, however I cannot do this due to the following...

Software situation: Windows 10 and Excel 2013. in an INTRANET there is an attendance list generated by Excel and saved (with VBA) as a pdf-file. If someone wants to modify his attendance record — for example to change his flexible working hours or free time — then he could open the underlying...

Hi Guys, Below is a macro for a user form I have in my workbook however I am struggling to add more viewable sheets per user. Dim bOK2Use As Boolean Private Sub btnOK_Click() Dim bError As Boolean Dim sSName As String Dim p As DocumentProperty Dim bSetIt As Boolean...

Hey everyone, first post here. I have a file that multiple users access on a shared network drive (sharepoint). I have this macro setup to update a .log file with the username and date/time when users open the file. Here's the logmessage code: Sub LogInfo(LogMessage As String) 'set path...

Hello people I have a workbook with some sheets. The user can acess some sheets, but other sheets are "secret". There's no buttons to acess these sheets, but if the user uses the shortcuts CTRL+PGDOWN or CTRL+PGUP is possible. I want to block the acess to some sheets. How could I do that?

Hi all I have been given a workbook to improve the functionality. The main issue is multi user access, the workbook is shared between about 10 users at any one time, all adding data to the same page. However due to the nature of the running VBA this workbook can not shared in the normal way...

Hello, I'm facing an information privacy issue at work. I will try to make it clearer using a simpler example. The current situation is as follows: 1 - There is a shared workbook in the server with 3 columns (A - orders / B -prices / C - production dates) 2 - 3 users accessing and working on...