Thread: how do I.....
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default how do I.....

Choose ViewToolbarsControl Toolbox
Click the Design Mode button
Select the CommandButton1, and click the Properties button on the
Control toolbox
In the Caption box, type "Generate Next PO"
Close the Properties window
Click the Exit Design Mode button

SCOTTF wrote:
sheet is not protected. i can create the button...assign the macro to
it clicking the button executes the macro perfectly...but i CAN NOT
change the text in the button.... it says "CommandButton1". I want it
to say "Generate Next PO".

other people may need to use this spreadsheet... they'll need to know
the function of the button....thanx for taking the time to help me plow
thru this!


Scott




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html