Mr_Mod
09-15-2011, 03:48 AM
Hi,
is it possible to have a login screen where a user does not need to enter a password and this will hide a button on the worksheet. Whilst when a user enter a password the button is visible and active.
I want to allow and admin person to be able to transfer data between the master workbook and the one field staff use but prevent the data person from accessing it as this would cause a macro to run.
The data entry person is out in the field and will not have any access to the master workbook which will be in the office.
I know how to create forms but lost when it comes to the rest of what needs to be done.
Help appreciated
is it possible to have a login screen where a user does not need to enter a password and this will hide a button on the worksheet. Whilst when a user enter a password the button is visible and active.
I want to allow and admin person to be able to transfer data between the master workbook and the one field staff use but prevent the data person from accessing it as this would cause a macro to run.
The data entry person is out in the field and will not have any access to the master workbook which will be in the office.
I know how to create forms but lost when it comes to the rest of what needs to be done.
Help appreciated