disable tab worksheet options

  • Thread starter Thread starter douglasmccormickjr
  • Start date Start date
D

douglasmccormickjr

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
 

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

disable worksheet tab options 5
Drag and drop 2
Worksheet CodeName property 1
Renaming worksheets 2
To protect user's privacy 1
Hiding the Insert New Worksheet tab in Excel 2007 3
Copying Sheets to a woekbook 1
Disable user interaction in VBA 1

Back
Top