EXCEL: Switching from READ-ONLY to READ-WRITE 
Author Message
 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



Sun, 05 Dec 2004 21:28:32 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Converting returned of a select query to read/write from read-only

2. Accessing a Property through read-only and read-write interfaces

3. Text box: read only/read write, how?

4. Need Folder permissions Read Only / Program Access Read Write

5. read/write without open workbooks in excel

6. Can QBasic write and read Excel files?

7. VB6 project reading/writing Excel spreadsheet

8. Read/Write to Excel 8.0

9. EXCEL FILE read and write

10. question about reading/writing Excel 5.0 files

11. read/write Excel 5.0

12. Excel file creation writing and reading

 

 
Powered by phpBB® Forum Software