read-only workbook

I have a MS Word VBA sub which opens an Excel workbook which was created and saved as UNPROTECTED and when the workbook is opened again it is read only. Other workbooks in the same folder are not opened by the sub and NOT affected. I am attempting to pull a string from the workbook and convert...

Hello, 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...

Hi, 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...

Hi guys! I have a private sub on "thisworkbook" Private Sub Workbook_open() Call module.macroname End Sub 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"...