Remain screen when a macro button use

[RJ1969]

Hello,

My macro button for border are in Sheet1. But when I click the button it goes automatically in Sheet2. Is there a way my screen will stay in Sheet1 when I click the button?

Please Login or Register  to view this content.

Thank you.

[vcoolio]

Hello RJ,

Add either one of the following just above End Sub:-

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[RJ1969]

Please Login or Register  to view this content.

Did not work. It said "compile error"

[vcoolio]

There's an unrequired dot(.) in the Goto line that I've just noticed.

Please Login or Register  to view this content.

Just remove the dot in front of Sheet1.

Cheerio,
vcoolio.