Test button function

Printable View

07-15-2006, 03:33 AM
mdmackillop

Test button function

How do buttons function in Excel if files are opened without downloading?
07-15-2006, 05:03 AM
johnske

Hi Malcolm,

I get a "macro not found" message for the forms button but the other works ok...

Regards,
John :)
07-15-2006, 08:13 AM
lucas

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:

Quote:

lucas 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"

http://vbaexpress.com/forum/showthread.php?t=8809
07-24-2006, 10:01 PM
Ken Puls

Both work for me, guys. :)
08-06-2006, 08:13 AM
lucas

Start at post #13
http://vbaexpress.com/forum/showthread.php?t=9061
08-06-2006, 08:37 AM
Ken Puls

No issue here again, guys. (Wife's PC too)

It's not an admin thing, or John would be having no errors either...
08-06-2006, 10:38 AM
Bob Phillips

Works fine for me.
08-06-2006, 02:45 PM
Desert Piranha

Quote:

I get a "macro not found" message for the forms button but the other works ok

I get the same as John.

Im using XP on broadband, Office 2000, Viewing with I.E.
08-09-2006, 07:48 AM
Zack Barresse

Both work for me as well. Do you think it makes a difference that your browser may need to have ActiveX control downloaded?
08-11-2006, 01:56 PM
Desert Piranha

Quote:

Originally Posted by firefytr

Both work for me as well. Do you think it makes a difference that your browser may need to have ActiveX control downloaded?

I don't know, when i come to this site i get a pop up that asks
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.