your code always appears to make the button visible again so I don't know why you expect it to be hidden? saveas affects the open copy of the workbook unlike savecopyas but savecopyas doesn't allow you to change anything