save as read only

neomod · Apr 10th, 2002, 03:13 PM

I currently have a command button that will save the workbook with current date as filename. Is there anyway to have it save the file as read only? I was also thinking of mabye manipulating the file once it's saved but I quess that wouldn't work since you can't change the attributes of a currently open file.

Jack in the UK · Apr 11th, 2002, 12:58 PM

Hi

Try adding and editing this :

ActiveWorkbook.SaveAs Filename:="C:My Documentstest macro delete.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=True, CreateBackup:=False
Range("A1").Select

Apr 11th, 2002, 12:58 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Try adding and editing this : ActiveWorkbook.SaveAs Filename:="C:My Documentstest macro delete.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=True, CreateBackup:=False Range("A1").Select __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 03:13 PM	#1
neomod New Member Join Date: Apr 2002 Posts: 6	I currently have a command button that will save the workbook with current date as filename. Is there anyway to have it save the file as read only? I was also thinking of mabye manipulating the file once it's saved but I quess that wouldn't work since you can't change the attributes of a currently open file.