Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Command button doesn't work

Posted on 2002-06-27
11
Medium Priority
?
170 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 800 total points
ID: 7116395
Sorry, i didn't see the button... :D
0
 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…
Suggested Courses

688 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