save all sheets

Hi Everyone! This is my first post here, and I am quite new to VBA, I could do with some help / advise please. I have a book that contains multiple sheets with user login / permissions. I need to save a copy of the ( current ) open workbook in .xlsm-format ( including the macros ), with a name...

Hello, I am trying to save multiple worksheets within one file to the same file location without having to pick the folder for every file that is being saved. The file that I am currently working in has 20 sheets that get saved. I am sure that I am missing something silly... Sub...

I am hoping someone can help me solve a puzzle here. I have a workbook with a number of tabs for which I have created macro to save each of these as it's own VBA file. When the files are saved the macro is designed to use the name of the tab combined with a predefined value and a date and time...

Hi, I have a workbook which a lot of people will be logging on to just put their name next to an activity. As I don't trust their housekeeping skills and the sheet works best to a newcomer in a certain format I want a button that say 'Save and Close' that will do the following: collapse all...

Hello, I've been working in a piece of code that changes, in another workbook, the name of each tab according to cell values and saves each worksheet as pdf file. It does change correctly the tabs name and saves them as PDF, also correctly (named according to each tab name). However the info...

I have a spreadsheet application that includes many macros, 15 visible sheets, and numerous hidden sheets. I have a macro button on the last sheet that saves a copy of this spreadsheet in the same folder where the main one is located (we call the newly saved copy "Scenario 1.xls"). However...