Solved

Command button doesn't work

Posted on 2002-06-27
11
162 Views
Last Modified: 2012-05-04
I have a simple website for Cabinetmakers using excel, where I have written some examples of useful ways to utilize the power of Excel.  It is at- http://www.geocities.com/billnjae/excel.html

Please look at this web page-  "DoorMaker... New!"

The "Sort" button does not seem to work when I try to use it as loaded from the website.  Works fine when I use the spreadsheet loaded from my machine.  Do you get the same issue?  Any ideas what is goofy?
0
Comment
Question by:cwbuck
11 Comments
 
LVL 5

Expert Comment

by:TheMek
ID: 7115855
http://www.geocities.com/billnjae/DoorCalc.xls
points to a page which doesn't exist (at least that's what yahoo/geocities says).
0
 
LVL 5

Expert Comment

by:rpai
ID: 7116341
Could you please elaborate the issue a bit?
As TheMek mentioned, http://www.geocities.com/billnjae/DoorCalc.xls does not exist.
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7116378
The excel sheet is protected.
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7116387
I meant, you cannot sort a sheet that it is protected (at least, not from menu, maybe with a macro)
0
 
LVL 16

Accepted Solution

by:
Richie_Simonetti earned 400 total points
ID: 7116395
Sorry, i didn't see the button... :D
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:cwbuck
ID: 7117738
Nope, don't think the protection is the issue.  I could be wrong though.  I'll give it a try anyways.   Richie, Excel normally sorts fine from a macro linked to a command button, even when protected. That is what the "SORT" button in this spreadsheet is.  However,  I am going to unprotect the spreadsheet now so anyonecan poke around better.
0
 

Author Comment

by:cwbuck
ID: 7117748
Yes, I see the link drectly to the spreadsheet does not work.  I imagine  Geocities must require you to go to the Index page first (so you can get the advertising banner I suppose).  

So use the first link I gave- http://www.geocities.com/billnjae/index.html
then click on "Excel for Cabinetmakers" then click on "Doormaker...New".  That will get you there, advertising banners and all.
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7117884
Angelfire do so too.
0
 

Author Comment

by:cwbuck
ID: 7121158
Richie-
I don't know how you did it, but you put me on the right track about the protection.   I unprotected the worksheet /objects and now the command button works fine from the website!  Could you go to the page and let me know if it works OK for you?
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7121804
What do you expect from me after a "C" grade?
0
 

Author Comment

by:cwbuck
ID: 7122425
Hey, I'd have gladly given you an "A" but honestly, you didn't REALLy figure it out at all. if in doubt about that, please re-read ypur comments. I thought you would be happy to get the 400 points.  I don't know if you noticed, but I added  200 points to the pot.  You seem to be a bit of a bad sport about this.  Am I missing something?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now