Creating a Save function in a worksheet cell

  • Thread starter Thread starter Tim Callahan
  • Start date Start date
T

Tim Callahan

in Excel, I would like to create a cell that when clicked
saves the file, but does not close out the workbook.
 
Hi Tim
why no use a CommandButton and assign the method
Activeworkbook.Save
to this button?

If you need a cell you'll need an event procedure!
 
Hi Frank,
This sounds Like what I would like to do. But being a very
early benginner, I am not sure how to do that. I have
figured out how to get the button on the worksheet but do
not know how to assign anything to it. Can you give me a
brief explation. Or is this too much for a beginner to go
after?

Tim
 
Back
Top