Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have shared workbooks. My code can unshare the workbook to unprotect
sheets and add named ranges. But I cannot convert the workbook back to shared mode. Can you help? Here is the code I have written to put the workbook back into shared mode, but it doesn't work. What am I doiung wrong? With ActiveWorkbook .KeepChangeHistory = True .ChangeHistoryDuration = 1 End With ActiveWorkbook.SaveAs Filename:= _ myProjectFolder & myProject , AccessMode:=xlShared ActiveWindow.Close Thank you for your assistance. -- Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disappearing comments in shared mode | Excel Discussion (Misc queries) | |||
Split Wokbook | Excel Discussion (Misc queries) | |||
Keeping Margins and Forcing Landscape mode on a shared Document | Excel Discussion (Misc queries) | |||
Problem with file in "Shared Mode" | Excel Discussion (Misc queries) | |||
how open dbf in shared mode? | Excel Programming |