How do buttons function in Excel if files are opened without downloading?
How do buttons function in Excel if files are opened without downloading?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hi Malcolm,
I get a "macro not found" message for the forms button but the other works ok...
Regards,
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
I ran Malcolm's file without downloading it and both buttons worked for me but I ran into a situation on the board where I posted a workbook with a userform and a forms button to open it....
without downloading it the button did not work for the person on the board for some reason. Not only that but they said they ran the userform.show macro and the activex button on the form did not work either. All buttons worked correctly if they downloaded the excel file and ran it from their hard drive. Error:
http://vbaexpress.com/forum/showthread.php?t=8809lucas I get 2 errors actually: 1) when I click on the "Form" button I get the following- "attachment.php?attachmentid=3492&d1152898232'!showform' cannot be found." and the form never displays 2) when I run the macro the form comes up and after entering a name and hit Add Info the following error comes up "Run-time error '1004':" "Method 'Range' of object'_Global'failed"
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Both work for me, guys.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Start at post #13
http://vbaexpress.com/forum/showthread.php?t=9061
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
No issue here again, guys. (Wife's PC too)
It's not an admin thing, or John would be having no errors either...
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Works fine for me.
I get the same as John.I get a "macro not found" message for the forms button but the other works ok
Im using XP on broadband, Office 2000, Viewing with I.E.
Dave
"The game is afoot Watson"
Both work for me as well. Do you think it makes a difference that your browser may need to have ActiveX control downloaded?
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
I don't know, when i come to this site i get a pop up that asksOriginally Posted by firefytr
if i want to allow Active X Controls to run and i answer Yes.
Any way i still get the:
I get a "macro not found" message for the forms button but the other works ok
I have always had to download xls files to get the macros to work.
Dave
"The game is afoot Watson"