I control a workbook that I update the majority of however I want to allow a select number of people to update certain parts without the need to share or remember passwords. I have linked a text box from the read only file to a seperate file that people can update and save but as they...
I have a read-only file with a userform which allows multiple people to use the userform without have the read-only prompt come up. I have done this so that I don't have to use sharing feature in the workbook as their are multiple issues that occur when doing so.
I would like people to be...
I have a private sub on "thisworkbook"
Private Sub Workbook_open()
It is a password protected wb for edit. (So if you didnt give the password when opening you can only read and can't save the file)
I want to edit this privatesub for dont run that "call"...