Hi Norie,
Thank you for looking into my code.
As I said, when I click on the drawing object which will take me to the home sheet of the macro and enables the second button.
when i click on this second button, the following code is there before above code is executed.
[CODE]
Sheets("Home").Activate
ActiveSheet.Next.Activate
[\CODE]
so, to answer your question, i think the code in above Activesheet is referring to the correct sheet.
Bookmarks