VBA Print / Save / Close

[mensageiro]

Hello everyone.

VBA is not my strongest point, so I'm asking if anyone can help me with this problem.

I have an Excel Workbook with 9 sheets.
In some of them, I want to have a button that, when clicked, prints the print area of that sheet, saves the whole workbook as the value of a cell (path is stored in another cell), and then closes the file.

I would also like to disable save and save as from the menu, and force the user to use the button to save the workbook.

Thank you in advance!

[ranman256]

in the workbook, enter VBE (alt-F11)
in the project window (ctrl-R, left pane) ,in your project book, Dbl-click ThisWorkBook
in the code area (right pane), at the top , the LEFT drop box ,click WORKBOOK
paste the code below into the code area.

Please Login or Register  to view this content.

this will prevent user from save/save as
BUT, your button must turn on the global variable gbSaveWB to bypass the save cancellation:

Please Login or Register  to view this content.

[mensageiro]

Thank you very much, ranman256!

Should I then create one module with the second code (and the print/save/close code) which can be applied to all buttons/sheets, or should I create one module per button/sheet?