Hi, Using VBA I need to be able to update a workbook whilst other users are using the file, As the file contains Pivots I cant simply share the file (using XL 2003 - upgrading is not an option). I thought I could lock the sheet down by making it read only password protected however the code which I am using to try to open the sheet does not run. Please could someone suggest a way to do this.
ActiveWorkbook.SaveAs Filename:= _
"\\lon0467xns\CogReporter\PVfiles\PV REC\PVREC_Pivots.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="PASSWORD", ReadOnlyRecommended:=True, _
CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
"\\lon0467xns\CogReporter\PVfiles\PV REC\PVREC_Pivots.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="PASSWORD", ReadOnlyRecommended:=True, _
CreateBackup:=False
