Hi,
I want the following code to be loaded automaticly when i open an excel file to prevent cells to be drag and dropped.
I have tried this with a clean sheet, but after closing and opening the file i could still "drag and drop" cells around.
Please Login or Register to view this content.
Anyone who can point me in the right direction?
With best regards,
Dinus.
DragAndDropTest.xlsm
your code needs to be in the Thisworkbook object not a standard code module.
Thanks Andy,
I have added it to the Thisworkbook code now (by Alt+F11, rightclick on 'ThisWorkbook, view code).
However, when i open the workbook i still can move cells around unless i enable the macro content first (i get the 'Macro's have been disabled' note).
Is there a way to solve this?
Wbr,
Dinus.
Last edited by Dinus; 11-28-2013 at 10:16 AM. Reason: typo
well yes if the macros are not enabled then you code will not run.
you could hide all the sheets and only unhide them via code.
Thanks Andy, that would work for me. Just to be sure, there is no way to auto enable macro's on startup?
Wbr,
Dinus.
Yes that is correct.
Thanks Andy.
/Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks