Before sheet copy

  • Thread starter Thread starter brownti via OfficeKB.com
  • Start date Start date
B

brownti via OfficeKB.com

Is there an action for beforesheetcopy? I want to run a userform prior to
copying a sheet. Is that possible?
 
no, there is no beforesheetcopy event.

The newsheet event doesn't seem to fire on a copy and would be after anyway
if it worked. I don't think you would be able to trap it before it happens.
 
You could protect the structure of the workbook so a sheet could not be
copied and force the user to use a menu or button.
 
I like that idea. That way i could incorporate selecting the tab color, and
name into the userform also so it is only one button click to do everything.
Is there an "easy" way of putting the color pallette in a userform, or does
someone have code to do it?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Hidden sheet bleeds through 3
How to enumerate buttons on user form 2
Help with copying a sheet from One workbook to another workbook 1
VBA copy and paste data 2
Code copies twice...? 13
How to use comma separated inputs in macro 4
Go to sheet based on ListBox selection 5

Back
Top