Hi Guys,
Hoping you might be able to assist with this query...in the body of a spreadsheet a worksheet name might be say Sheet1. When viewing the object in the VBA editor is might have a name of Sheet8. Is it possible to use macro code to rename the VBA editor name to agree to the sheet tab name.
Look forward to reading your suggestions.
Thanks.
Michael.
Hoping you might be able to assist with this query...in the body of a spreadsheet a worksheet name might be say Sheet1. When viewing the object in the VBA editor is might have a name of Sheet8. Is it possible to use macro code to rename the VBA editor name to agree to the sheet tab name.
Look forward to reading your suggestions.
Thanks.
Michael.