Force save as entire workbook and save as a pdf select cell range

Elliottj2121

New Member
Joined
Apr 15, 2021
Messages
18
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
For the background, I have a form template created that uses VBA to populate entered data in the form to specific columns on a sheet. The user clicks "Enter Reference" on the "Enter Reference" completes the form (attached images 1 & 2), then the data on the form populates in the correct columns on the "Data" Tab (mini sheet data)

Is there a way to have a prompt pop up when the user opens the template forcing them to enter a string of text, like a customer name, and then that entered text followed by the word "references" is a new file name that saves on the desktop?
For example,
1. User opens template.
2. Pop up prompt says "please enter customer name". User enters customer name, e.g. "Acme Company"
3. Then a new file is saved on the user's desktop named "Acme Company References" and that workbook automatically opens up.

Secondly when the user has entered all the necessary data in the form. can a "button" be made on the "data" sheet that says "Save References as PDF" and only cells A1:O20 save as a scaled to one page pdf file on the desktop?

Any help would be greatly appreciated



Form Template 1.1.xlsm
ABCDEFGHIJKLMNO
1Ref#Steel SupplierSold SinceLast SaleADP High Balance Current Over 30 Over 60 DiscPromptNSFCommentsSupplied by
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Data
 

Attachments

  • form image1.jpg
    form image1.jpg
    19.3 KB · Views: 2
  • form image2.jpg
    form image2.jpg
    69 KB · Views: 2

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,141,707
Messages
5,707,979
Members
421,539
Latest member
zuniBM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top