button can save

Hi, i have a button on my spreadsheet to save the sheet as a PDF but i can figure out how to get it to create a copy of the file in excel with the same name and save both that copy and the PDF in the location of where the file original file is saved this is my code currently: Private Sub...

Hi Like many others,i have a simple problem with excel/VB. I would like to calculate the sum of each dish ordered in one evening. To this point i have each order added up to an amount and then emptied again with a button. I had that cell copied to another cell so that it can be added with...

Hi all, I would like to make a button on each sheet of a workbook which will save the sheet (excluding the button) as a PDF to the desktop. Each sheets starts off as a blank sheet, the blank sheet is copied and data entered, sheet renamed as needed. The data on each sheet will be reviewed...

Hi, Can you please help me with my problem. I am currently creating a checklist and I need to disable save and save as function. I have a button shape to be clicked to save the file which is still subject to the following considerations: 1. Column B is intended for Processor checks. If the...