Adding a command button for :REVIEW

Thanks Bakerman2!!

i tried to set up the code above, but I keep getting a Runtime error 424: Object Required message. I do not think I have my code set up properly. Can you send an example of how the entire code should look like? When the command button is click I need it to take the user to the ADD_EXTEND worksheet.

i have uploaded another copy of the spreadsheet without any code, but i cannot seem to be able to disable the password prompt
when you open the file.

I apologize for the late response. The password is SPAR. I cannot figure out how to get the workbook to stop asking me for a password when I try to open it.

I think you sent the wrong file. There is only the ADD-EXTEND button on the screen.

Gotcha, you are a genius!! This is perfect!! One thing that just hit me, if a user that is not on the authorized list
clicks the Review button, what do I add to the code to display a message that states "You are not Authorized". Below is
the code you used.

Private Sub UserForm_Initialize()
Review.Enabled = (Environ("username") = "Rudi")
End Sub

That works great. Thank you very much for your help, and patience!!

Originally Posted by bakerman2

You're welcome.

Bakerman, Sorry to steal this topic. I am saw your code and it is indeed very usefull. I am trying to convert to my own needs. Buit i am stuck in a small problem.

For example:

Please Login or Register  to view this content.

Is there a property fields somewhere cause for example [BUoM].Value, i cannot see my new selections when i run the macro.