Create button to print a separate workbook without opening.

[EnviroBob]

Excel macro novice here.
I have a Customer info workbook my employees need access to. see pic. On the "form" column, the "Y" indicates a specific printable form is needed for their job that is in another workbook that I don't want them to have access to. I would like to make the "Y" a button they can press and print the form without opening the form workbook. I've read that I may need to convert the forms to pdf. Any help would be appreciated. Thanks for your time.

 

[t0ny84]

This code would be a start.

Sub PrintHiddenWorkbook()
    Dim wb As Workbook
    
    ' Open the workbook without displaying it
    Set wb = Workbooks.Open("C:\Path\To\Your\File.xlsx", False, True) ' Replace with your file path
    
    ' Print the specific sheet
    wb.Sheets("SheetName").PrintOut ' Replace "SheetName" with the name of your sheet
    
    ' Close the workbook without saving changes and without prompting
    wb.Close SaveChanges:=False
End Sub

 

[EnviroBob]

This code would be a start.

Sub PrintHiddenWorkbook()
    Dim wb As Workbook
   
    ' Open the workbook without displaying it
    Set wb = Workbooks.Open("C:\Path\To\Your\File.xlsx", False, True) ' Replace with your file path
   
    ' Print the specific sheet
    wb.Sheets("SheetName").PrintOut ' Replace "SheetName" with the name of your sheet
   
    ' Close the workbook without saving changes and without prompting
    wb.Close SaveChanges:=False
End Sub

Brilliant! Thank you! I've got the rest figured out. Cold beverage of your choice to you, sir.