I used VBA code to keep my first tab in the front, but now i can not copy paste info from one tab into another in the same workbook. Is there a way to fix this?
Please Login or Register to view this content.
I used VBA code to keep my first tab in the front, but now i can not copy paste info from one tab into another in the same workbook. Is there a way to fix this?
Please Login or Register to view this content.
No, not really. Whenever you change worksheets the event will fire and the undo stack will be cleared.
You could use the workbook open or close events to position your worksheet just once instead.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks