disable tab worksheet options
 

Hello out there,

I want to insert a VBA script that will disable a specific
event/operation in excel. I want to prevent a user to drag and drop an
excel worksheet tab into another workbook. Just to clarify, this is
achieved by users clicking down on the sheet tab and dragging it into a
new workbook. I also want to protect the tab structure so users can't
rearrange sheet order (I''ve figured out how to disable rename/delete)

Thank you in advance,

-Sanbitter Man

disable tab worksheet options
 

You marked your message so that the followups would go to .misc.

Any reason?

wrote:

Hello out there,

I want to insert a VBA script that will disable a specific
event/operation in excel. I want to prevent a user to drag and drop an
excel worksheet tab into another workbook. Just to clarify, this is
achieved by users clicking down on the sheet tab and dragging it into a
new workbook. I also want to protect the tab structure so users can't
rearrange sheet order (I''ve figured out how to disable rename/delete)

Thank you in advance,

-Sanbitter Man

--

Dave Peterson