Command Button

  • Thread starter Thread starter EngelseBoer
  • Start date Start date
E

EngelseBoer

This excel is driving me nuts - seems to not have ALL its functions
I have added a Command Button that i want to cause "save as...." when pressed.
However i cant assing ANY command to it.
it remains un-pressable - kinda like just a picture of button..

all "help" info fais to tell me what to do...
Please help

Regards
Malcolm
 
I am assuming you are in design mode. My question is, is your sheet
protected? If your sheet is protected, and the button you created is
'locked', then even in design mode you will not be able to do anything.
 
click VIEW in the menu, select TOOL BARS and the click the CONTROL TOOLBOX to
display the tool bar.

The first button on the toolbar has a triangle/pencil/ruler and this is the
toggle that turns DESIGN MODE on/off.

Click to turn this off and see if things work as planned. If you haven't
added your code, turn design mode back on and right click on the command
button and select VIEW CODE to open the workhsheet VB module.
 
Thanks Kevin-I am soo dumb with these things (but i am trying)
Now.... How can i assign a amcro to select a particular Cell (which contains
a name) - when this button is pressed - so that it will save a copy of that
page under a different name - so that the original remains un-affected.
I need this for a web - input page
naturally i don't want the input page altered, but i want the input stored.

I have created this page using an excel web form.

Regards
 
Are you trying to save just a worksheet as a new file? I'm not clear on what
you're trying to do.
 
yes,
without altering the original
required for a web-based-input form
there must be no opertunity to over-write the original, but automatically
save as the inputted name on the sheet (are save them as consecutive
numbers-never over-writing other forms)
 
someone has assited me with this under a new Rqeury (16 above this one tiled
"save as" macro..

however i still need to assign that macro to the "save" (command button) i
created
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use multiple command button to copy user form data to multiple worksheet 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Code for Command Buttons 1
losing command button functionality 4
Command Buttons 3
Command Button Excel 2007 4
command button code 2
Command button macro 6

Back
Top