Hi Experts,
Please help me writting VBA code to open an excel sheet of a workbook in Read-only mode.
Lets say. Book1 is the excel workbook, which has spreadsheets Sheet1, Sheet2 and Sheet3. I want Sheet2 should be Read-only everytime when i run macro.
Please help.
Hi,
Have you thought of just protecting the worksheet?I hope this helps
Worksheets("Sheet2").Protect
Actually, Book1 is in Shared mode.
Could you please help, because in shared mode sheet cannot be protected. Thats why, i'm looking for read-only mode of a perticular sheet.
Hi, Nanimadhu,
I think it´s the same for every workbook whether shared or not: it´s either read-only or not for all the worksheets inside. Maybe consider splitting the workbook up into different ones.
In a normal workbook it should be possible to switch between the states although at present I can´t figure a reason to do so.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Nanimadhu 
Register To Reply
Bookmarks