Macro Security Issue using CheckBoxes in Design Mode
HelloAll,
So ive incorporated checkboxes into my spreadsheet using the design toolbar. The only issue is, i keep getting a macro security level is too high error message. I need these to work without getting this error. They are not linked to anything, they are in the spreadsheet as purly astetics.
Any ideas?
I need these to work with macro security on high.
I never wrote a macro for these boxes, so im unsure as to why its telling me my security is too high...
Thanks so much,
Eric
Eric
What type of checkboxes are they ActiveX or Forms?
If posting code please use code tags, see here.
I am unsure. I am using the control toolbox that looks like this:
DesignTab.JPG
Apparently if i click the "show code" button, the code looks like this:
Please Login or Register to view this content.
So im understanding now why its using a macro. But it should be by a trusted publisher...since im using a built in excel tool bar...right?
If you can think of any other way to accomplish the same task im more than willing to try it.
Thanks for all the help,
Eric
Last edited by EricSomin; 08-07-2013 at 12:52 PM. Reason: Its the control tool box. not design tool box...Sorry
Eric
Where do you see that's code?
Is it in a worksheet module or standard module eg Module1m
Norie,
I Think that may be my issue. If i Open VBA it doesnt show this code at all. But if i click the button on the toolbox that says "View Code" this is what pops up:
VBAWindow.JPG
So as far as i know, this isnt a macro within a module at all...Its within the design VBA form....To be honest im completely lost. This doesnt make any sense to me...
The code is in a worksheet module.
What happens if you remove the code, save and close the workbook, then reopen it?
Do you still get the security message?
By the way, the publisher of a workbook is the person (or organisation?) who creates it, not the application that it's created with.
Hi Norie,
I can not delete this code...i delete it, then save, and it comes right back up.
I do understand that the publisher is whoever creates the macro, and thus each publisher must have a license. However, this code is not one that i typed myself. It is implimented by opening up the toolbox, and clicking the checkbox button. Hence, i am confused as to why i would need to lower macro security to allow the computer to run a macro that is already built into the Microsoft Office programming.
Is there another way to impliment check boxes that i may not be aware of?
Thanks so so much for all the attention and help,
Eric
Eric
That code will only be there if you right click and select view code.
Otherwise there's no code associated with the control.
Yes, I do that and see this:
CodeWindow.JPG
Then i delete the text. and save the VBA window, and the Excel Window.
Then if i grab the pulldown menu from the screen shot, and select for example (Checkbox 1) the text comes right back. even though i just deleted it and saved....
Eric
You are describing the steps you would take to add the code.
Don't select view code.
Don't select the control from the dropdown.
Then the code will never be created.
hahaha, so this is like quantum physics....Its only there if i see it...if i dont look at it, the computer wont think its running a macro. and hence i dont need to lower my macro security.
I opened a new workbook and tested this, and it does seem to work. However ive now opened the code on my main workbook. Is there a way to undo this. So i can keep my high security as well as use my checkboxes?
If i do a new save as, will that work??
Thanks for all your help!
Eric
Eric
The code will only be there if you add it, if you don't add it there's nothing there, there is no macro, the computer isn't running a macro.
I think we are having a bit of a miscommunication.
Excel is adding this code for me whenever i add a new checkbox. I am not typing the code. I am not adding a macro. I am simply opening a tool bar. and using a tool on that tool bar.
This is also leading to my confusion. Why would excel initiate a macro for a built in tool. It just doesnt make sense to me
When I add a control Excel doesn't create any code.
The only way I can get Excel to create code is to,
select the control, right click and select View Code
or,
open VBE, goto the worksheet module of the sheet with the control on it and then select the name of the control from the left hand dropdown
or.
double click the control.
If I don't do one of those no code is created
Okay, I must have done one of those things and created this code. Is there a way to remove it so I can contunie to use my checkboxes without getting this error?
Or do i need to make a new file?
Eric
I've sometimes accidentally double clicked and ended up with code, usually I've wanted it though.
Anway to get rid of it: delete the code, save and close the workbook and then reopen it.
The code will be gone, and it won't appear again unless you do one of the things I mentioned.
You are a savior....
I am not new to programing. But this was confusing me like crazy. So the code only exists if i look at it....That makes NO sense. But i think ive got this all resolved now.
Thank you so much for all of your time and patience helping me with this.
Eric
No, it doesn't exist because you look at it because there's nothing to look at unless you create it.
ie the code doesn't not exist unless you create.
It's not hiding somewhere, it just isn't there.
hahaha, so clicking "View Code" brings the code into existence....gotta love the way Microsoft thinks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks