Specializing Protection of workbooks and worksheets while running macros.

Okay,

I have a workbook that has a password protection on it so that only certain users can access it.

I have a homepage with 3 different buttons that load 3 different user forms. When the form is in Read Only, 2 of those buttons disappear and 1 remains.

This remaining button is made for users who are not granted as much access as the users who can view all 3 buttons.

Is there a way for the user with less access to be able to only update the spreadsheet through the user form? without having to save it as something else?

Is there a special or different way to go about this?

I have attached my workbook.
The password is "steel123"

BUMP- no responses.


Any suggestions would be nice on how to secure certain parts of my workbook