
EXCEL: Switching from READ-ONLY to READ-WRITE
If a workbook is opened as READ-ONLY is there a way to
programmically reopen the book as READ-WRITE from a macro
contained within the workbook? In other words can a macro
within a READ-ONLY workbook close the workbook and then
reopen it for READ-WRITE.
I have a workbook that MUST default to being opened as
READ-ONLY, once the user reviews the data I want to give
them a command button that will 'UNLOCK' the workbook
(open it for READ-WRITE) if any data needs to be changed.
thx