Thread: [Solved] Autofill SaveAs File Name box using read only workbook
View Single Post
 
Old 05-20-2015, 11:16 PM
excelledsoftware excelledsoftware is offline Windows 8 Office 2003
IT Specialist
  
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default
I think the only issue is the 3rd line of code. The workbook name does not include the file extension at least not in my experience. Change it to
Code:
 If ThisWorkbook.Name = "Test" Then
and see if that fixes it.

Thanks
Reply With Quote