Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable worksheet tab 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable worksheet tab options
Why post under two names within a minute of each.
-- Don Guillett SalesAid Software "Sanbitter Man" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable worksheet tab options
I checked it, what should I be seeing?? There's nothing there.
"Dave Peterson" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable worksheet tab options
It looks like microsoft has picked up my post in the google support group as
well...I thought these 2 groups were exclusive of each other...Did you have any information that relates to answering my question/post? "Don Guillett" wrote: Why post under two names within a minute of each. -- Don Guillett SalesAid Software "Sanbitter Man" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable worksheet tab options
You can stop them from moving the worksheet by protecting the workbook.
Tools|Protection|protect workbook|Check structure. Be aware that this protection can be broken quite easily. (And this same option disables the rename/delete as well as insert) Sanbitter Man wrote: I checked it, what should I be seeing?? There's nothing there. "Dave Peterson" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Options in 2003 | Excel Discussion (Misc queries) | |||
disable tab worksheet options | Excel Programming | |||
Programmatically disable new smart options | Excel Programming | |||
Disable commad bar options | Excel Programming | |||
Disable options | Excel Programming |