I have this code assigned to a button in excel 2003 but when I open the file in excel 2010 the button does not work. Any help would be appreciated. The file is opened in compatibility mode. It's .xls
Thanks!
Please Login or Register to view this content.
Last edited by 6StringJazzer; 01-08-2014 at 10:34 AM. Reason: code tags
Excel 2010 disables macros specially if the file is xls and not xlsm could that be the problem. It also request permission for the macros to be enabled
Try enclosed file.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
OK. So I guess the only way to make this work in 2010 is to save it as an .xlsm? Thanks!
The xlsm by Herry works fine.
No its not like that... When the file opens just Click Enable Macros thats enoughOriginally Posted by rwstarkey
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Something is odd because it doesn't give me the option of enabling macros, I've got all macro security wide open right now in 2010, but when I open the .xls file the button does not work at all and the view macros shows no macros at all. I'm wondering if the way I attached the VBA code to the button in 2003 is somehow not working in 2010? It's been awhile so I can't remember exactly how I did that button design in 2003.
ideas?
Thanks!
Ok... Whether it is a ActiveX control if not you can pick that macro by pressing Alt+F8 and run it.
Please check and confirm
Another option just add that workbook path in trusted location and check, because the trusted location path files will have full rights to run macros automatically which prompting to enable macros
That's the problem. No macros show up. So somehow code that works on that button in 2003 doesn't show up as a macro in 2010, and also won't run via the button. I can see it in VBA when I go to design / show code, but the button is unresponsive and no macros are showing. Ugh.
Open the 2003 file Just create a new button and assign the macro and check
OK. I wonder how I assigned VBA code to that button orginally? :-)
I believe it is a Active-x control
What menu its showing when you right click the Button.
Yeah it's showing view code, not select macro. So that won't transfer directly to 2010? Thanks!
Click View code and copy the code and Just create a new activex control and do right click and select view code and paste it
Hi, rwstarkey,
Your opening post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Looks like the buttons in 2003 were corrupt or old or just not compatible with 2010. I recreated them and they then worked in 2010. Thanks!
rwstarkey, you posted soon after HaHoBe so I assume you missed his request and I won't cite you for ignoring the request to follow our rules. Please take the time to review our rules. There aren't many, and they are all important.
I have updated your post because you are a new member but please use CODE tags next time.
OK. My apologies. I'm used to free-flowing open forums mostly so I'll review how it rolls here and do that for sure. Thanks!
No harm done. I participate on a general purpose discussion board that basically has no rules except "don't be a jerk." On this board, in contrast, we're more structured because the board has a particular focus and we want every thread to be informative and beneficial. So we want good thread titles so they can be found with searches, code tags for readability, notice if you cross-post so people don't waste time solving a problem that's already been solved somewhere else, etc.
Welcome and I hope you enjoy the community here!
OK. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks