User access

[Mathew599]

Hi i need help.
I have create workbook that has a userform. I have users and admin accounts.
However with the user accounts they are still able to copy/delete worksheets. Is it possible to make these options only available for my admin accounts?

I have looked at protecting the workbooks structure etc, but this stops users logging in and my command macro buttons from working.

 

[Trevor G]

Welcome to the forum Mathew599, one suggestion is create a sheet showing users details and have a column listing there admin level rights and then you could use the workbook event of on open to show the form and based on the access list can make other sheets available or not, protected or not.