Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
modify without unprotecting the sheet, Unsolved question | Excel Programming | |||
unprotecting a worksheet | Excel Discussion (Misc queries) | |||
Unprotecting! | Excel Programming | |||
Unprotecting! | Excel Programming | |||
Unprotecting! | Excel Programming |