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...

This Week's Hot Topics

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