ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unprotecting Question (https://www.excelbanter.com/excel-programming/354401-unprotecting-question.html)

ew

Unprotecting Question
 
I have a file that is first shared and secondly each sheet is shared. What
I'm running into is the part of the code that makes the file unshared. This
is the code so far. Thanks for any help in advance....

ub Unprotect_All()

Dim fileToOpen As Variant
Dim ws As Worksheet
Dim Wbk As Workbook


fileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls")

Application.ScreenUpdating = False
ActiveWorkbook.ExclusiveAccess
For Each ws In Worksheets
ws.Unprotect
Next ws
Application.KeepChangeHistory = True
Application.SaveAs _
AccessMode:=xlShared
Application.ScreenUpdating = True

End Sub


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com