workbook save

  1. D

    Prevent Change in File Extension?

    Hello, Is there an effective way to prevent a user from changing the file extension of a file? For example, if a file needs to remain .xls I want to prevent a user from changing it to .xlsx, etc. I assume I would need to add code to the Workbook_BeforeSave event? Or is there a better way...
  2. V

    Check if the workbook has ever been saved

    Hi, I have followed this forum for a while and found many great solutions to expand my VBA experience. However, I cannot find any solution to the following situation. I have a macro that downloads a .xlsx file and copy the worksheet to the users activeworkbook. If the user is working in an...
  3. J

    VBA Share/Unshare with Multiple Users Saving

    Hello, I've looked through many posts but I don't think I can find any for my problem (sorry if I'm wrong). I have a shared workbook that many people will be using (and probably at the same time). I have a few macros in the book that, when run, unshare the book, unprotect the particular sheet...
  4. C

    Open all workbooks to perform an action

    I need to a workbook in a specified folder, copy any sheet that contains "Dec" to a new workbook, save and repeat for all worksbooks in a folder Here is the code I have so far and it only opens all the files in the folder I specified but doesn't take the action to copy the sheets I have...
  5. V

    More than one event in workbook object?

    Hey guys, This may be a dumb question because I've been looking for an answer all over the internet and can't find the problem mentioned anywhere. I'm relatively new to Excel VBA though, and I'm trying to create two events for a single workbook. Is this possible? I have one workbook open...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top