LinkBack URL
About LinkBacks
Hello,
I am adding a new worksheet by copying one into MyWorkbook, using ALT / E /M ALT+C.
MyWorkbook has a sub:
which won't trigger.
Please Login or Register to view this content.
What is wrong here?
Could you please advise?
Thanks
Hello,
I am adding a new worksheet by copying one into MyWorkbook, using ALT / E /M ALT+C.
MyWorkbook has a sub:
which won't trigger.Please Login or Register to view this content.
What is wrong here?
Could you please advise?
Thanks
IT works when I add a new sheet manually. Does it trigger when you add new sheet manually?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Yes, if I add it manually, than it works.
I just tried it by adding a sheet through VBA and it worked then too. I'm not sure what your key combinations are doing to create a new sheet though.
Hi plans,
Your shortcut key strokes are coping an existing tab in the workbook. This is not adding a new worksheet (small difference I know) so the NewSheet workbook event doesn't execute. There is no event to capture the copying of an existing sheet to the current workbook.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks