View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default disable worksheet tab options

Check your original post.

Sanbitter Man 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