Excel Protected Worksheet
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-08-17 03:38 PM
Hello,
Can anyone please attach/upload to this post a modified Excel VBO to open an excel sheet with a password ?
I tried to implement it in the Open Excel action but no success.
Thank you
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-08-17 04:01 PM
Hi,
The following code put into a new code object will unprotect a worksheet called ""File"".
Dim wb As Object
Dim ws as Object
Try
wb = GetWorkbook(Handle, Workbook)
ws = wb.Worksheets(""File"")
ws.Unprotect(Password)
Success = True
Catch e As Exception
Success = False
Message = e.Message
Finally
wb = Nothing
End Try
I duplicated the ""Protect Worksheet"" object and modified the code stage with this code. Replace the hard coded value ""File"" with the name of your worksheet.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-08-17 07:18 PM
Thanks a lot Neville. Could you please forward the xml to this adress: mahmoud.barrak@fr.ey.com ?
Thank you!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-09-17 12:02 PM
Hi,
Could you also please forward the xml to this adress: scully2501@free.fr?
Because, I have a error ""The given key was not present in the dictionary""
Thank you
