PDA

View Full Version : Userform Read only to Read/Write



WES29
09-13-2018, 08:42 AM
I am trying to have a series of userforms that will allow users to view the information in our database. I have a button that changes from read only to read/write but it closes the userform. How do i stop it from closing the userform?

Logit
09-13-2018, 10:04 AM
.
Post your code.

Please utilize the # from the above menu.

WES29
09-13-2018, 10:27 AM
Private Sub Rite_Click()



ActiveWorkbook.ChangeFileAccess Mode:=xlReadWrite


Home.NewJob.Enabled = True
Home.NewWO.Enabled = True
Home.Manage.Enabled = True
Home.Rite.Visible = False
Home.Reed.Visible = True




End Sub

Logit
09-13-2018, 11:00 AM
.
I don't see anything that would open or close a userform.

WES29
09-13-2018, 11:25 AM
This is the code for the button to switch from Read only to Read Write. As soon as it executes it shuts the user from and opens the workbook.