Assigning a button to SAVE a sheet

J

John Petranek

Trying to assign a cell name as SAVE and have it save the sheet I am working
on to a folder when I click on it. Is this possible?

Thx
 
F

FSt1

hi
confused. do you want to save the sheet to another file with name in a cell??
or do you just want to save a range on the sheets? is the folder a fixed
file path?
button? do you mean a command button on the sheet or icon on the toolbar?

regards
FSt1
 
F

FSt1

hi
after reading your other post, i think this may be what your are after.

ActiveSheet.Copy
'Workbooks.Add
'Range("A1").PasteSpecial xlPasteAll
Application.Dialogs(xlDialogSaveAs).Show


you wont be able to type the word save in a cell to launch the macro. you
can put a label from the control toolbox on the sheet, size it to the same
size as the cell, then type the word save in the label. the right click the
label and click view code.
this should default in......
Private sub label1_chick()

end sub
paste the above code between sub and end sub.

Regards
FSt1
 
Top