View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eighthman11 eighthman11 is offline
external usenet poster
 
Posts: 17
Default Can't see the properties for a button???

On Sep 4, 3:04*pm, "JLGWhiz" wrote:
The button is probably from the Forms Toolbar. *It has limitation on the
properties that can be adjusted. *the one you added probably came from the
Control Toolbox which is much more liberal in the properties adjustment
area. *The code for the Forms Toolbar button usually resides in a public
module like Module1, while the Tool Box button will have its code in the
host code module, either the Worksheet or Userform.

"eighthman11" wrote in message

...



Using Excel 2003. *I have adopted someone else spreadsheet. *I am not
an excel expert. *When I right click a button on the spreadsheet while
in "Design Mode" I can notsee"Properties" or "View Code" options for
the button. *I don'tseewhere any "Protection" has been put in place
for the spreadsheet.


I added my own button to the spreadsheet and I canseethe "Properies"
and "View Code" options when I right click the button I create.


Any help appreciated. *Like I said I am not an expert, just someone
who got stuck with a project.


thanks ray- Hide quoted text -


- Show quoted text -


Thanks Guys you were right. The buttons were created from the FORMS
Toolbar and a Macro assigned to it. Once again thanks for the help.
I was going crazy Ray