Turning off “Drag Fill Series” in Excel
I am ideally looking to only turn off the drag fill series functionality.
I only want the user of my sheet to be able to drag COPY down.
I turned the feature off in settings, which disable ALL drag downs. I would be happy with that, but of course this only works in my own Excel settings, other users of the sheet will still be able too in the context of their settings.
I am wondering if there is a way in VBA to turnoff the fill series features or disable the drag feature entirely?
microsoft-excel vba
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
add a comment |
I am ideally looking to only turn off the drag fill series functionality.
I only want the user of my sheet to be able to drag COPY down.
I turned the feature off in settings, which disable ALL drag downs. I would be happy with that, but of course this only works in my own Excel settings, other users of the sheet will still be able too in the context of their settings.
I am wondering if there is a way in VBA to turnoff the fill series features or disable the drag feature entirely?
microsoft-excel vba
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
add a comment |
I am ideally looking to only turn off the drag fill series functionality.
I only want the user of my sheet to be able to drag COPY down.
I turned the feature off in settings, which disable ALL drag downs. I would be happy with that, but of course this only works in my own Excel settings, other users of the sheet will still be able too in the context of their settings.
I am wondering if there is a way in VBA to turnoff the fill series features or disable the drag feature entirely?
microsoft-excel vba
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
I am ideally looking to only turn off the drag fill series functionality.
I only want the user of my sheet to be able to drag COPY down.
I turned the feature off in settings, which disable ALL drag downs. I would be happy with that, but of course this only works in my own Excel settings, other users of the sheet will still be able too in the context of their settings.
I am wondering if there is a way in VBA to turnoff the fill series features or disable the drag feature entirely?
microsoft-excel vba
microsoft-excel vba
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
edited Nov 19 '12 at 11:55
Paul
48.2k14122148
48.2k14122148
asked Nov 19 '12 at 11:53
KotoKoto
1412
asked Nov 19 '12 at 11:53
KotoKoto
1412
asked Nov 19 '12 at 11:53
KotoKoto
1412
1412
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
You can use the following in VBA to disable Cell Drag and Drop when the workbook opens.
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
End Sub
In order to avoid making people angry, you should turn it back on when the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CellDragAndDrop = True
End Sub
You can use the IF statement to check if the feature is turned on off/on to ensure you return it to the original state. The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f507636%2fturning-off-drag-fill-series-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
You can use the following in VBA to disable Cell Drag and Drop when the workbook opens.
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
End Sub
In order to avoid making people angry, you should turn it back on when the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CellDragAndDrop = True
End Sub
You can use the IF statement to check if the feature is turned on off/on to ensure you return it to the original state. The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
add a comment |
The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
You can use the following in VBA to disable Cell Drag and Drop when the workbook opens.
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
End Sub
In order to avoid making people angry, you should turn it back on when the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CellDragAndDrop = True
End Sub
You can use the IF statement to check if the feature is turned on off/on to ensure you return it to the original state. The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
add a comment |
The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
You can use the following in VBA to disable Cell Drag and Drop when the workbook opens.
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
End Sub
In order to avoid making people angry, you should turn it back on when the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CellDragAndDrop = True
End Sub
You can use the IF statement to check if the feature is turned on off/on to ensure you return it to the original state. The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
You can use the following in VBA to disable Cell Drag and Drop when the workbook opens.
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
End Sub
In order to avoid making people angry, you should turn it back on when the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CellDragAndDrop = True
End Sub
You can use the IF statement to check if the feature is turned on off/on to ensure you return it to the original state. The biggest challenge you will face is Macro Security on the individual machines. If they are not set to run Macros this will keep this from running.
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
edited Nov 21 '12 at 12:25
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
answered Nov 19 '12 at 14:00
CharlieRBCharlieRB
20.5k44490
20.5k44490
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
add a comment |
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
When closing the workbook down, I am getting an error box emerging: Compile Error, Ambiguous name detected: BeforeClose . I have saved both your macro's in "This Workbook" macro sheet as opposed to an individual sheet macro.
– Koto
Nov 20 '12 at 11:35
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Private Sub Workbook_BeforeClose() Application.CellDragAndDrop = True End Sub how does this macro know that the workbook is closing?
– Koto
Nov 20 '12 at 11:45
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
Excel knows and executes the event handler/subroutine automatically when the event occurs. Also, the declaration should be Private Sub Workbook_BeforeClose(Cancel As Boolean) ... End Sub
– Karan
Nov 20 '12 at 16:40
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f507636%2fturning-off-drag-fill-series-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
