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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.